We have a spreadsheet created by our CFO a few years ago. The spreadsheet accesses Sharepoint (Services 2003) and updates information entered by staff. It runs in Excel 2010/2007.
He's since moved on and we had left his account active. A genius decided last month to remove his account (me unfortunately) as it was no longer being used for anything.
Unfortunately now when we use the spreadsheet we are unable to refresh. Entering any credentials will give an error:
"An unexpected error occurred. Changes to your data cannot be saved."
Recreating his account and making him an owner of the site hasn't helped. We now get this error when logging in as him as well.
I'm stumped where to go from here. I am no Sharepoint expert (and a long way short of it).