I have read almost all the posts about personal.xls either here or some
other Excel tips website. but couldn't find one solution for my situation.
this one is close to my problem, but my problem is even worse than that.
(http://www.pcreview.co.uk/forums/thread-3183383.php)

I upgraded office to 2007 at the end of last December. Before upgrading, i
saved the personal.xls in a disk. after upgrading, i was going to load the
macros in this file to a new macro workbook.

i double clicked my dear "personal.xls", got a message "the file
you are trying to open, "Personal.xls", is in a different format than
specified by the file extension. Verify that the file is not corrupted
and is form a trusted source before opening the file. Do you want to open
the file now?". then i chose "yes". then go to developer, click macro, chose
"myoldPersonal.xls", got empty content. where is my macro?? ?I click Edit,
another message, " can't edit hidden workbook, unhide workbook by using
unhide command".

ok, then i unhide it. go to macro, still empty. close it. open it again,
same message, "the file you are trying to open........", click yes, go to
developer, chose macro, chose this personal.xls file, empty content!! click
edit, this time no more message, but vba window shows no modules in there...

where are my macros?? the size of personal.xls is big, seems my macros still
there. but i can't get them shown up.

i searched lots of posts, couldn't find a solution. i gave up. please help
me!!

thank you so much!!

PS, i learned a lot when i read the posts. Dave Peterson, Ron Bruin, many
other experts...thank you...

Regards,
Lin