Solved

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

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

Technology Partners: 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!

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

688 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