29 January, 2010

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/

23 December, 2009

Authenticated Users get Access Denied when Browsing to Site- 403 Forbidden

When NT Authority\Authenticated users were added to a windows sharepoint services 3.0 site, users other than the users directly permissioned to site, or Site Collection Admins would receive a 403 Forbidden error when they woudl try to browse to the Default.aspx page.

ULS Logs would show:
============================================================
Access Denied for /default.aspx.
StackTrace: Microsoft.SharePoint.Utilities.SPUtility:Void
HandleAccessDenied(System.Exception), Microsoft.SharePoint.SPGlobal:Void
HandleUnauthorizedAccessException(System.UnauthorizedAccessException),
Microsoft.SharePoint.SPWeb:System.String GetWebPartPageContent(System.Uri,
Microsoft.SharePoint.WebPartPages.PageView, System.Web.HttpContext, Boolean,
Boolean, Boolean, Boolean, Boolean ByRef, Byte ByRef, System.String ByRef,
System.Guid ByRef, Int64 ByRef, System.Guid ByRef, UInt32 ByRef, System.String
ByRef, Byte ByRef, System.Object ByRef, UInt32 ByRef, System.Object ByRef,
Microsoft.SharePoint.SPWebPartCollectionInitialState ByRef, System.Object ByRef,
System.String ByRef, Boolean ByRef, System.Guid ByRef),
Microsoft.SharePoint.ApplicationRuntime.SPRequestModuleData:System.String
FetchWebPartPageInformationForInit(System.Web.HttpContext,
Microsoft.SharePoint.SPWeb, Boolean, System.String, Boolean, Boolean ByRef, Byte
ByRef, System.Guid ByRef, UInt32 ByRef, System.String ByRef,
Microsoft.SharePoint.SPFileLevel ByRef, System.String ByRef, System.String ByRef,
System.String ByRef, System.String ByRef, System.Guid ByRef, System.Object ByRef,
Microsoft.SharePoint.SPWebPartCollectionInitialState ByRef, System.String ByRef,
System.String ByRef, System.Object ByRef, Boolean ByRef, System.Guid ByRef, Int64
ByRef), Microsoft.SharePoint.ApplicationRuntime.SPRequestModuleData:Void
GetFileForRequest(System.Web.HttpContext, Microsoft.SharePoint.SPWeb, Boolean,
System.String), Microsoft.SharePoint.ApplicationRuntime.SPRequestModule:Void
InitContextWeb(System.Web.HttpContext, Microsoft.SharePoint.SPWeb),
Microsoft.SharePoint.WebControls.SPControl:Microsoft.SharePoint.SPWeb
SPWebEnsureSPControl(System.Web.HttpContext),
Microsoft.SharePoint.WebControls.SPControl:Microsoft.SharePoint.SPWeb
GetContextWeb(System.Web.HttpContext),
Microsoft.SharePoint.ApplicationRuntime.SPRequestModule:Void
PostResolveRequestCacheHandler(System.Object, System.EventArgs),
System.Web.HttpApplication+SyncEventExecutionStep:Void
System.Web.HttpApplication.IExecutionStep.Execute(),
System.Web.HttpApplication:System.Exception ExecuteStep(IExecutionStep, Boolean
ByRef), System.Web.HttpApplication+ApplicationStepManager:Void
ResumeSteps(System.Exception), System.Web.HttpApplication:System.IAsyncResult
System.Web.IHttpAsyncHandler.BeginProcessRequest(System.Web.HttpContext,
System.AsyncCallback, System.Object), System.Web.HttpRuntime:Void
ProcessRequestInternal(System.Web.HttpWorkerRequest), System.Web.HttpRuntime:Void
ProcessRequestNoDemand(System.Web.HttpWorkerRequest),
System.Web.Hosting.ISAPIRuntime:Int32 ProcessRequest(IntPtr, Int32),
==================================================================

after detailed analysis and debug of the w3wp process, we found two columns with non standard settings in the content database. In the AllList table the columns called tp_readsecurity and tp_writesecurity, for the “User Information List” have the values set to 2 & 4 respectively. The default value for both columns is 1.

Tp_readsecurity

Value="1">read all items
Value="2">read only my items
Value="4">read none


Tp_writesecurity

Value="1”>write all items
Value="2">write only my items
Value="4">write none

The value 2 for tp_readsecurity will only allow a user to read their own items. So reading the items does not occur because it is trying to read the items in the “user Information list” that are not their own. The value 4 for tp_writesecurity does not allow write to this list so you will not be able to add users. Since they have not or cannot be added into the list, there was an exception being thrown and this is the reason for the 403 Forbidden.

RESOLUTION/WORKAROUND:
===========================
1. Open the site you are having trouble with, but make sure you open the site
with site collection admin/owner rights.
2. Browse to the URL:
http://portal/sites/site/_layouts/advsetng.aspx?list={GUID}
3. This List ID will vary.
4. You can also get to this list by Browsing to the root of your site, Site
Actions> Site Settings> Advanced Permissions> Click on the All People link
in qiuck launch> Then select List Settings, then Advanced Settings
5. This method will also get you to the above URL and probably easier than
having to poke thru the DB to find the GUID of that list.
6. Change the Read Access Value to “All Items”
7. Change the Edit Access to “All Items”
7. This will modify those values in the database back to 1 and 1
8. Authenticated Users should now be able to access the site.

I hope the above information will helps you to resolve this issue !! Thanks !!!