Excel 2000 sheet no display correctly in Excel 2003

By rlphillips ·
Sheet created in Excel 2000 has list boxes and picture inserted from a file.
When opened in Excel 2003 the picture and list boxes do not show.
Macro is supposed to be running but I cannot find it.

The data for the list box can be seen when you unhide data area.

Compared the Excel options but do not see anything different.
Excel 2000 is running on PC with Windows 200 Pro.
Excel 2003 running on PC with Windows XP Pro

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Check security settings ............

by ThumbsUp2 In reply to Excel 2000 sheet no displ ...

In Excel 2003, click Tools -> Options -> Security Tab -> Macro Security. Set it to medium.

Collapse -


by rlphillips In reply to Check security settings . ...

Security is set to medium. I tried Low also. no luck.

Collapse -

Find macros

by ThumbsUp2 In reply to Reply

If the macros were originally stored in a hidden workbook attached to the file you opened in Excel 2000, those hidden workbooks need to be in a different place in Excel 2003.

Open the file in Excel 2003, then click Window -> Unhide. Look for the other workbook to appear. Now click Window -> Hide and click Save. When you exit Excel, you will be asked if you want to save the hidden workbook as well. This will place a copy of the hidden workbook into the XLSTART folder where it belongs.

Collapse -

Lists are the main functional change between these versions

by Chris910 In reply to Excel 2000 sheet no displ ...

I ran into similar problems and found that Lists where one of the main changes between 2000 and 2003. I found that when I switched versions I had to First Remove The List and then Reapply the list before using the spreadsheet.

I noticed that the Office 2007 compatibility pack has been released. This may be helpful in adding the capability of saving in the 2007 format from 2000 and 2003. Here is the link

Related Discussions

Related Forums