Solved

Excel; 2007:  Errors were detected while saving

Posted on 2010-09-16
3
4,275 Views
Last Modified: 2012-05-10
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
Comment
Question by:regosnell
3 Comments
 
LVL 7

Accepted Solution

by:
hippohood earned 500 total points
Comment Utility
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
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
Don't use Shared Workbooks. They are notorious for corruption, file bloat and weird behaviour.
0
 

Author Closing Comment

by:regosnell
Comment Utility
End user re-created the document and has had no issues since.  Thanks
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

728 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

11 Experts available now in Live!

Get 1:1 Help Now