Solved

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

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

708 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now