Personal Macro workbook not recognizable in Excel 2000

H

hmm

I run Excel 2000 on my PC, in order to handle those charting tasks that Excel
2007 is very slow at.

Recently, upon opening E-2000, I get an error message that "The file is not
in a recognizable format." I press OK, upon which PERSONAL.xls opens as a
text file of incomprehensible control characters. The file opens and works
normally in E-2007. From there I try to save it as an Excel 97-2003 file, in
(the unlikely) case it was in the wrong format; but it is still not
recognized when opening in E-2000.

Can anyone tell me why such a problem exists, and how to solve it? Thanks.
 
S

Squeaky

You can only have one personal file, either the one for excel 2000,
(personal.xls) or the one for 2007 (personal.xlsm). Even though they are
different files with different extentions only one will work at a time. It
will be in the XLSTART folder. (Do a search in documents and settings for
"personal.xl"
You can just simply relocate the personal.xls file to another location, or
delete it.

If you only have personal.xls you should convert it to a 2007 version, then
move the 2000 version.


Squeaky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top