Solved

Excel access to Sharepoint - User acct deleted

Posted on 2013-05-15
4
347 Views
Last Modified: 2013-06-17
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
Comment
Question by:tonydav67
  • 3
4 Comments
 
LVL 2

Author Comment

by:tonydav67
Comment Utility
Anyone able to help?
0
 
LVL 8

Expert Comment

by:vaderj
Comment Utility
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
 
LVL 2

Accepted Solution

by:
tonydav67 earned 0 total points
Comment Utility
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
 
LVL 2

Author Closing Comment

by:tonydav67
Comment Utility
No assistance from EE.  Worked out on my own.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now