Solved

Excel 2007 templates getting corrupted after editing...how to fix temporarily and permanently

Posted on 2013-06-07
3
180 Views
Last Modified: 2013-06-21
hi Folks
Have Excel templates on a network drive. Users make a copy of the document, complete it on a tablet and the completed version is sent to another folder via SyncToy. So users are working with a worksheet based on the template NOT the template
What is happening is that when the template is edited (and these are basic forms - no validation, conditional formatting, macros) the following message comes up..
See attached screenshot.
This has happened more than once. The fix at the moment has been to rename and resave the template but I'd be concerned that it would happen again (and again) and would like your advice with the following..
1. Are there any Excel recovery tools you would recommend (there are about 30 files in question)?
2. What would you recommend as good practice to keep this to a minimum?
3. Am thinking of porting all the documents over to Word (there's been no problems with the Word documents)

As always thank you.
EE-excel-problem-screeenshot.JPG
0
Comment
Question by:agwalsh
  • 2
3 Comments
 
LVL 22

Expert Comment

by:rspahitz
ID: 39229305
Not sure of all the ins and outs of this, but do you get the same "corruption" message on other machines? i.e. you copy the template to a local machine (rather than opening it directly from the network), does the error appear?  And are there any machines where it works fine with the template?

And what version of Excel?  It looks like 2007/2010.  Is the machine opening this using an earlier version (e.g. 2003) with the compatibility module installed to read the xltx file?  Not sure how reliable that conversion is...

One possible way to handle it is to first open Excel then use the File/Open dialog box, single-click/select the file, then on the Open button, click the little dropdown arrow next to it and select "Open and Repair..."

Other than that, I'm not sure what's going on with Excel.
0
 

Author Comment

by:agwalsh
ID: 39229972
I've actually tried that already - the Open and Repair - no joy :-(
and essentially the template has to be on the network...that's where the users go to create the document. yes it's Excel 2007 and most of them were created in that. I've tried opening it in a number of ways and it's frustrating. Was wondering if anyone had any recovery tools they could recommend....
0
 
LVL 22

Accepted Solution

by:
rspahitz earned 500 total points
ID: 39230843
I didn't mean to take it off the network...merely to make a local copy to see if the problem still exists.  If so then you know the problem has to do with the network and may or may  not be an excel issue.
Also, if you bring it locally and update it, then upload it back (rather than edit the version while it's on the network) the problem may get fixed.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

770 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