Solved

Excel files on share getting corrupted.

Posted on 2012-04-03
2
159 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
Comment Utility
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
Comment Utility
I believe the file does have macros. Let me try renaming it.
0

Featured Post

Network it in WD Red

There's an industry-leading WD Red drive for every compatible NAS system to help fulfill your data storage needs. With drives up to 8TB, WD Red offers a wide array of solutions for customers looking to build the biggest, best-performing NAS storage solution.  

Join & Write a Comment

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
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…

772 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