Solved

Excel access to Sharepoint - User acct deleted

Posted on 2013-05-15
4
435 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 2

Author Comment

by:tonydav67
ID: 39173339
Anyone able to help?
0
 
LVL 8

Expert Comment

by:vaderj
ID: 39242439
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
ID: 39243003
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
ID: 39252616
No assistance from EE.  Worked out on my own.
0

Featured Post

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

738 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