Solved

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

Posted on 2013-06-07
3
187 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

861 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