Excel 2002 and SharePoint- Unable to open and edit the spreadsheet and save
Today one of the SharePoint Users called me for help with Sharepoint. The User was trying to open the Excel Spreadsheet from Sharepoint and was not able to make any changes or edits to the document and also could not save any changes. when he tries to open the Excel Spreadsheet(.xslx). the spreadsheet opens up in the web browser but will not allow the user to make any changes and the option to save it is not available.
I remoted in to his machine and found that the user had Office 2002 installed on his machine. Once we upgraded the current version of office 2002 to office 2007, everything worked like charm....
2007 Word Format changes after Users modified the document using the previous versions.
One of the strange things I recently noticed was,the users who had previous versions of office on their desktops, make changes to the server document by editing it from Sharepoint. When they were done with the changes and try to upoad and save the document using the previous version, the default template changes and all the formatting will be lost.
This is more common if the document were saved in the latest format and modified by other users using the previous versions. The whole formatting was lost in the Process.It took some time to figure out why this strange thing is happening.
Finally the issue was resolved successfully.