Solved

Corrupt Excel 2010 file

Posted on 2012-03-28
3
368 Views
Last Modified: 2012-06-27
I have a user that has an excel file that was created in Excel 2003. She put a password on it so others could view but not update the file.

I just upgraded her to Office 2003 standard. Now when she tries to open the file, she gets a message that the file is corrupt and cannot be opened. Others can open the file in protected view using Excel 2010. I also saved it to my desktop and sent to her and she gets the same error. Not sure how to attack this.....thanks
0
Comment
Question by:jslaymon
[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 8

Expert Comment

by:twohawks
ID: 37777731
Are you sure the file was not converted to a 2010 format - which is incompatible with versions prior to 2007?
".xlsx" or ".xlsm" uses the newer xml encoding.
If its like that, then open it in 2010, save as excel 97-2003 workbook.

You have likely already checked this, however, I think its the first thing ;^)
0
 

Accepted Solution

by:
jslaymon earned 0 total points
ID: 37778871
It was originally saved as a 2003 doc. I got around it the old fashion way. I copied and pasted the data into a new 2010 spreadsheet then saved it as a 2010 doc and added the protected view.....thanks
0
 

Author Closing Comment

by:jslaymon
ID: 37795173
figured it out
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
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…

726 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