?
Solved

Excel files on share getting corrupted.

Posted on 2012-04-03
2
Medium Priority
?
169 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
sdwalker earned 1500 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
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 how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

762 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