From a sharepoint list, I chose Actions -> Export to Spreadsheet
, saved the owssvr.iqy
file, opened this file, and tried editing entries in Excel.
When I try to edit any columns, I am shown: "The xxxx column is a read-only column that cannot be modified."
I did a Google, which suggested a couple of ideas:
One link suggested using sysinternal's ProcMon to see what is happening. However, I didn't see the registry entries it suggested I should see.
Another link suggested it could be something blocking an 'OPTIONS' request to the sharepoint server?
Another link suggested it could be because I have SP3 of Excel 2003?
Another link suggested checking the registry entries for
HKCU\Software\Microsoft\Office\11.0\Common\Internet\Server Cache
, but these entries looked OK?
[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\Internet\Server Cache\https://xxxx.o2.com/sites/xxxx/]
"Type"=dword:00000005
"Protocol"=dword:00000003
"Expiration"=hex(b):30,CD,6b,8a,c6,6a,ca,01
Has anyone else seen this, and found a way around this?