Solved Office 2003 Excel file will not open with Office 2007

November 13, 2015 at 19:33:13
Specs: Windows 7 Home Premium, 6 GB
I have an Excel file which has some moving objects as well as some drop down menus. I recently installed MS Office 2007 after erasing 2003. The Excel tables now are disabled, the file now looks like a picture, only the fields outside of the content are really clickable.

I have tried to enable all macros, downloaded the MS compatibility pack, still same issue. Any suggestions/ideas? The file works in 2013 and 2016.

I can share the file upon request ...


See More: Office 2003 Excel file will not open with Office 2007

Report •


✔ Best Answer
November 27, 2015 at 21:12:00
Thank you for your suggestions, here an update: I got the file working - how, no idea. I re-opened the original attachment, deleted the one I had on my PC and voila, it works.


#1
November 14, 2015 at 07:45:57
Just wondered, is it a normal xls file?

Always pop back and let us know the outcome - thanks

message edited by Derek


Report •

#2
November 14, 2015 at 14:45:23
Hi, what is normal? It has an .xls ending. It has drop down menus to convert days from one calendar system into another.

Report •

#3
November 14, 2015 at 16:44:36
My shot in the dark - Office 2007 may not recognize whatever you used to create the "moving objects and drop down menus" in Office 2003.

i_Xp/Vista/W7/W10 User


Report •

Related Solutions

#4
November 14, 2015 at 17:16:52
Sorry, I just meant file extension xls. In which case I can't add anything - maybe #3 is the answer.

message edited by Derek


Report •

#5
November 15, 2015 at 15:39:23
Two thing to try:

In 2007 you can run a Diagnostic:

Running Microsoft Office Diagnostics from within Excel/Word

Click the Microsoft Office button
Click on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Resources button in the left hand pane
Click on the Diagnose button in the right hand pane
Click Continue
Click Run Diagnostics

Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button
Click All Programs
Click Microsoft Office folder
Click Microsoft Office Tools
Click Microsoft Office Diagnostics
Click Continue
Click Run Diagnostics

See if that is on any assistance.

Also, you can do an Open & Repair

Click the Microsoft Office Button
Then click Open.
In the Open dialog box, select, do not double click, just highlight the corrupted workbook.
In the Open drop down button, lower right of window,
Select the Open and Repair.

You can then do one of the following:
1) To recover as much of the workbook data as possible, click Repair.
2) To extract values and formulas from the workbook after an attempt to repair fails, click Extract Data.

See if that helps.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#6
November 27, 2015 at 21:12:00
✔ Best Answer
Thank you for your suggestions, here an update: I got the file working - how, no idea. I re-opened the original attachment, deleted the one I had on my PC and voila, it works.

Report •

#7
November 28, 2015 at 05:44:01
Glad to hear you are OK now and thanks for letting us know. Yeah, at odd times problems do seem to fix themselves, often after a restart.

Always pop back and let us know the outcome - thanks


Report •

Ask Question