Home » Questions » Computers [ Ask a new question ]

Sharepoint List Exported to Excel - Columns are readonly

Sharepoint List Exported to Excel - Columns are readonly

From a sharepoint list, I chose Actions -> Export to Spreadsheet, saved the owssvr.iqy file, opened this file, and tried editing entries in Excel.

Asked by: Guest | Views: 199
Total answers/comments: 1
Guest [Entry]

"After clicking Open you need to go to the Properties dialog and then uncheck the Save Query check box.

This would make your column editable."