Solved

Excel files on share getting corrupted.

Posted on 2012-04-03
2
161 Views
Last Modified: 2012-04-09
Hi Team,

For the past few weeks we've been experiencing an issue with one of our shares. This share hold a lot of excel files and the 3 files that are accessed mostly on daily basis keep on getting corrupted and loosing the formulas on the cells. When the file is open excel stops responding and then when you open the file again it looses the formulas. We have tried opening the file in different computers, same problem. All computer that access the file are running office 2007.

Any help will be greatly appreciated.
Thank you
0
Comment
Question by:exTechnology
2 Comments
 
LVL 12

Accepted Solution

by:
sdwalker earned 500 total points
ID: 37802338
I had a similar issue once and my issue was that I had a macro in a spreadsheet that had the same name as a macro in an add-in they were using.  It would corrupt the sheet and we'd have to copy a backup over and hope it worked.  May be totally unrelated, but wanted to share that just in case.
0
 
LVL 2

Author Comment

by:exTechnology
ID: 37802490
I believe the file does have macros. Let me try renaming it.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Trying to figure out group policy inheritance and which settings apply where can be a chore.  Here's a very simple summary I've written which might help.  Keep in mind, this is just a high-level conceptual overview where I try to avoid getting bogge…
This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

777 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