Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Corrupt Excel 2010 file

Posted on 2012-03-28
3
Medium Priority
?
370 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

610 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