Solved

Excel files on share getting corrupted.

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Freeze Panes Solution 6 28
In search of x17-22375.exe 2 10
Excel macro runs twice 13 46
help with changing the VBA to ignore if sheet exists 6 15
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
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 demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

914 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

19 Experts available now in Live!

Get 1:1 Help Now