• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

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

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
agwalsh
Asked:
agwalsh
  • 2
1 Solution
 
rspahitzCommented:
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
 
agwalshAuthor Commented:
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
 
rspahitzCommented:
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now