Improve company productivity with a Business Account.Sign Up

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

Excel; 2007: Errors were detected while saving

There is a spreadsheet that is of type Excel 2007.  I have three people using this excel document all day long.  This workbook is shared and kept open most of the day.

I have one user who saves the file and occassionally will receive an error:

Errors were detected while saving g:\Electronic elgibility\2010_electronic elig and group tracker.xlsx

Microsoft office excel maybe able to save the file by removing or repairing some features.  To make repairs in a new file, click continue, to cancel saving the file, click cancel.

Not sure this helps:  The one getting the error is using RDP to a windows 2008 R2 box, the others are running the file off of their XP Pro PCs.  The file itself resides on a Windows Server 2003 box.

I have suggested 1)  Copy data to a new workbook and/or 2) try and save file as type .xls

Unfortunately my users are looking for "better solutions."

Any help is appreciated.
0
regosnell
Asked:
regosnell
1 Solution
 
hippohoodCommented:
Most likely, you have a version problem. You have to try saving file as a compatible version (which would be Excel 97-2003 xls). If it solves the problem then there are no other (easy) solutiuons.
If doesn't - check the troubled machine for the following issues:
- not enough drive space or memory (may have similar problems when saving Office files locally)
- network issues (LAN or VPN connection comes and goes)
If nothing helps, try sharing this file on a different server. You may have to use a SharePoint solution for collaboration work
0
 
Rory ArchibaldCommented:
Don't use Shared Workbooks. They are notorious for corruption, file bloat and weird behaviour.
0
 
regosnellAuthor Commented:
End user re-created the document and has had no issues since.  Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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