29 January, 2010

The converter failed to save the file

Computer running office 2007 try to open an excel file from SharePoint site for edit. Error: (Save as) The converter failed to save the file. However, if user start the Excel program before opening the file from SharePoint, no problem at all, no error message and file saving fine. 

The fix is to do the following:
- Open Word
- Click the Office button (Top-left in the window)
- Click Word Options
- Click Resources
- Click the Diagnose button
- Click through the wizard until it’s finished
- Close all browser windows

I hope the above information will helps u to resolve the issue!!

In case of any queries/questions then please let me know. I would be more than happy to help you as well as resolves your issues. Thank you.

Excel cannot open the file 'filename.xlsx' because the file format for the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file

When you try to open a workbook that you receive in an e-mail message for review in Microsoft Office Excel 2007, the workbook does not open. Additionally, you receive the following error message:
Excel cannot open the file 'filename.xlsx' because the file format for the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
This issue occurs only when you send a workbook for review. The workbook file is saved as an Excel binary workbook. However, the workbook has an .xlsx extension that is appended to the file.

To work around this issue, save the workbook as one of the following file formats before you send the workbook for review:
--Excel Binary Workbook (*.xlsb)
--Excel 97-2003 Workbook (*.xls)

26 January, 2010

The document information panel was unable to load. The document will continue to open. For more information, contact your sys admin.

I have a custom field type as a dropdownlist which displays the no. of users from the web site. Now I have a document library with this custom field type. When I tries to create a item it opens the MS Word instance and it gives a message as Document Information Panel is unable to load.

After lots of research and debugging the issue on my dev-env, i was able to resolve the issue.
The Steps taken for resolution:

1. Open this location- C:\Program Files\Microsoft Web Designer Tools\Office12\1033\IPEDINTL.DLL
2. copy IPEDINTL.DLL
3. paste it here- C:\Program Files\Microsoft Office\Office12\1033\IPEDINTL.DLL
4. Close all the applications that are presently open as well as all the browsers
5. Open the sharepoint site in a new browser and check the results !!

Please let me know in case of any issues.. Thanks !! I hope, the above steps will helps you to resolve your issue regarding the same !!

16 January, 2010

Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists

1. Install the excel 2007 add-in on your machine.

http://www.microsoft.com/downloads/details.aspx?FamilyId=25836E52-1892-4E17-AC08-5DF13CFC5295&displaylang=en

2. When you will start the setup then it will ask you where to install the data excetely, so please save at this location on your machine:
C:\Program Files\Microsoft Office\Office12\ADDINS

3. Open the excel sheet in which you have the data that you wants to synchronise in sharepoint.

4.Click the Microsoft Office Button, click Excel Options, and then click the Add-Ins tab.

5. Select Excel Add-ins in the Manage drop-down list and click Go.

6. In the Add-Ins dialog box, click Browse, navigate to the Excel 2007 SharePoint List Synchronizing Add-in, and then click OK.

7. In the Add-Ins dialog box, verify that the SynchronizeWSSandExcel option is selected and then click OK.


To add the add-in to a workbook

1. Save the workbook in the Excel 97-2003 (BIFF8) file format by clicking the Microsoft Office Button, pointing to Save As, and then clicking Excel 97-2003 Workbook.

2. Specify a file name, and then click Save.

To publish the table to a SharePoint list1. Highlight the table. The Table Tools label is displayed above the Design tab.

2. Click the Design tab.

3. In the SharePoint group, click Publish and allow Sync.

4. When you will click on click Publish and allow Sync. then all the data will be disappeared from the excel sheet and transferred to SharePoint List.

5.In the Export Table to SharePoint R/W List dialog box, in the Address text box, type in the page address onthe SharePoint site where you want to publish the list.



6. In the address, Please enter your site link without default.aspx

7. Type the name of the list that you want.

8.When you will click on Publish then the internal process will create a list by the name that you specified and all the data will be transferred to sharepoint site.

Note: When you will click on Publish then you will get some error message.. Dont worry abt that as the data has been transferred to sp-site.
If you have any questions or queries regarding the above procedure then please let me know..

30 December, 2009

Method 'Post' of object 'IOWSPostData' failed

The error message --Method 'Post' of object 'IOWSPostData' failed --appears when I import a spreadsheet in the Create -Import Spreadheet menu of MOSS 2007.
Importing lists from Excel 2007 returns a Method 'Post' of object 'IOWSPostData' failed dialog. The problem is not with the sharepoint but result of a failed Application.SharePointVersion() call in the Excel Add-In which results in Excel attempting to use the IOWSPostData.Post() method to publish the Excel range which is used with SharePoint Services.

By forcing the version lookup result variable to 2 or greater, Excel will use SOAP to communicate with SharePoint and the publish request will be successful.

To make this change, Please follow these steps:

1. open the Excel Add-In EXPTOOWS.XLA locate in

C:\Program Files\Microsoft Office\Office12\1033.

2. Press Alt+F11 to display the Visual Basic code editor and search (Ctrl+F) for the line lVer = Application.SharePointVersion(URL).

3. Comment out that line with a single quote and add the line lVer=2 so your Intialize() method should now look like this:

Sub Initialize(List, Title, URL, QuickLaunch)
strQuickLaunch = QuickLaunch
aTarget(iPublishURL) = URL
aTarget(iPublishListName) = List
aTarget(iPublishListDesc) = Title
'lVer = Application.SharePointVersion(URL)
lVer = 2
End Sub

If you have any doubts or queries regarding the above procedure then please let me know...
I hope the above information will helps you to resolve your issue..Thanks !!


Reff:http://social.technet.microsoft.com/forums/en-US/sharepointgeneral/thread/75b2be6b-44df-4389-bf34-c7a01c12372c/