Solved

Corrupt Excel 2010 file

Posted on 2012-03-28
3
359 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
  • 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
My experience with Windows 10 over a one year period and suggestions for smooth operation
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
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…

707 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

13 Experts available now in Live!

Get 1:1 Help Now