The list cannot be displayed in Datasheet view...

By -
If you get this message,

The list cannot be displayed in Datasheet view for one or more of the following reasons:

- A datasheet component compatible with Microsoft SharePoint Foundation is not installed.
- Your Web browser does not support ActiveX controls.
- A component is not properly configured for 32-bit or 64-bit support.

when you try to open the Sharepoint 2010 List in the DataSheet view, do the following :

install the 2007 Office System Driver: Data Connectivity Components after you install Office 2010 64-bit on the machine.


Hope this helps


Comments

Anonymous said…
That helped - thanks!
8:29 PM
Anonymous said…
I am running Windows Server 2008 R2 with 64-bit IE and 64-bit Office and this download worked like a charm! thanks!
1:54 PM
Anonymous said…
Good day I am so grateful I found your weblog, I really found you by error,
while I was browsing on Aol for something else, Anyways
I am here now and would just like to say thanks for a incredible post and a
all round thrilling blog (I also love the theme/design), I
don't have time to look over it all at the minute but I have book-marked it and also added in your RSS feeds, so when I have time I will be back to read more, Please do keep up the superb work.

Also visit my weblog prescription glasses for women
6:59 AM
Post a Comment

Popular posts from this blog

Power Apps - Restricting the Text Box only Whole Numbers

By Vinod Thachin -
Image
 We can restrict the a Text box to allow only number by making the Format TextFormat.Number as below.  But this will allow decimal Number. We can restrict the Text Box to allow only whole numbers by writing the formulae for the TextBox Onchange as below If(     DataCardValue1.Text <> "" And Value(DataCardValue1.Text) <> RoundDown(         Value(DataCardValue1.Text),         0     ),     Notify("Please enter number without decimals");     Reset(DataCardValue1) )
Read more

Power Apps toPower Automate Error - The input body for trigger 'manual' of type 'Request' did not match its schema definition , the input String does not validate against the date

By Vinod Thachin -
While working with power Apps to Power automate, passing the Date time values as Text(DateTimeValue) throws error as below. The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'String '' does not validate against format 'date'.'. After checking the Microsoft documentation and few blogs i found out the date values should be passed as a formatted date time. TO pass the date time  we need to use following functions. Text(<<DateTimePicker>>.SelectedDate,"[$-en-US]yyyy-mm-dd") Even after passing the value i am still seeing the same issue and finally found out the default value ids sending as empty and formulae failing for empty values. So we need to make sure the Date Value should not go blank to the formulae and the value should be formatted using the formulae as above. Hope this helps.
Read more

ETAG mismatch (Conflicts exist with changes on the server, please reload)

By Vinod Thachin -
While working with one of the screen Save button, i see error while patching the SharePoint list data. After investigating the issue, I found it is due to old data that is pulled to the screen. As per Mozilla Documentation in the link , ETag is http response header to a version of a resource. It will help to save the time to avoid unnecessary transactions. If there is no changes in the content, it will not send response to the web server. So as there is no change in the List,  Etag will not send response to the web server and it returns the error. So when we save the list it throws error. To avoid the issue, we need to refresh the Data Source in the after Patching the list. In my Case, i have updated the Refresh as below. Path(<< DataSource >>,<< Item to be Updated >>,{<< Column >>:"Yes"}); Refresh( << DataSource >> ); After adding Refresh() function it worked as expected. Hope this helps.
Read more