Solved

Excel files on share getting corrupted.

Posted on 2012-04-03
2
163 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

My experience with Windows 10 over a one year period and suggestions for smooth operation
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 Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

685 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