Cannot paste data into datasheet view
I have a user who is reporting a problem when trying to copy/paste data from Excel 2007 into a MOSS 2007 Datasheet view. This functionality was working for her previously as recently as last month. According to the user, she has not had any changes done to her machine recently (same machine, still using IE7, no recent installs). I tested the copying/pasting feature from my machine and I also cannot paste into the datasheet view. My colleagues do not have an issue though. Has anyone run into this problem before? My gut reaction is that this is a broswer issue, rather than a SP issue but I am not seeing any browser settings which appear to apply. Any suggestions?
April 27th, 2010 9:57am

Sephiro On your development environment try creating a new list with the default columns. From here try editing in datasheet view and copy and paste info into it. It works for me and it should work for you. Next is understanding that copying and pasting data in the datasheet view might not work if there are multiple lines of data and the columns from both the source and the destination do not match.Kanwal SharePoint Buzz
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2010 11:57am

Kanwal, Thank you for the post. I have tried that and it appears that I still cannot paste into any datasheet view. Even a newly created standard one with a few basic text columns. I can also confirm that the columns on the Excel file exactly match the columns in SP. In my last position, I used to do this all the time and it was never an issue. I initially thought this might be a browser setting, but the portal site is listed as a trusted site in IE. I also tried copying/pasting from Excel 2007 into other applications (Outlook, NotePad, etc...) and that all works fine. It's just the SharePoint datasheet views which will not allow me to paste information (if I click on a cell in the datasheet twice, so that I can see the cursor, then the paste works but it pastes all of the data into that one cell rather than across the cells).
April 27th, 2010 12:20pm

If Content Approval is enabled on a document library, the datasheet view will always open in Read-Only mode. -Mukesh
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2010 1:47pm

All, I was able to resolve the issue. It turned out to be an issue with the Excel file itself. If we copy/pasted the data in the Excel file to a new worksheet as Values only, we could then copy/paste that into SharePoint. At some point along the way, the user had made configuration changes to that Excel file. Once we rebuilt the file from scratch, then both the user & I could paste into SP again. Many thanks to those of you who proposed solutions. I've never come across this before and it was a bit perplexing there for a while.
April 27th, 2010 3:50pm

Just tried this with a user who has been having the same problems for "ages" no-one found a fix for it - until I read this. Thanks.
Free Windows Admin Tool Kit Click here and download it now
May 10th, 2012 6:44am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics