Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 469
  • Last Modified:

Excel access to Sharepoint - User acct deleted

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).
0
tonydav67
Asked:
tonydav67
  • 3
1 Solution
 
tonydav67Author Commented:
Anyone able to help?
0
 
vaderjCommented:
i would determine why it requires his account? if it is for access to files on sharepoint, can you login using a site collection administrator account and have it work? it sounds like the errors are coming from Excel - does your company have a SharePoint 2010 installation?
This might be somthing that can be recreated as a dashboard or somthing along those lines
0
 
tonydav67Author Commented:
Thanks vaderj for your post.  I ended up re-exporting the report and then using the data definition created in the old report.  This worked.
0
 
tonydav67Author Commented:
No assistance from EE.  Worked out on my own.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now