Solved

Corrupt Excel 2010 file

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel 2010 Sparklines - horizontal bar 2 139
Error 5180 Word Cannot open document template 1 32
Need a poor man's PowerPoint 5 75
Generating a graph via Excel 3 28
Introduction It seems that at least a couple of times per month, I answer a question that requires automating Outlook from another Microsoft Office application, usually (although not always) to send one or more email messages.  For example: …
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…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

863 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

28 Experts available now in Live!

Get 1:1 Help Now