I don't use xl2007 much, but this site:

http://technet2.microsoft.com/Office....mspx?mfr=true

says that xlsx is a file with no macros.

So that macros are gone doesn't seem like a surprise.

Marcela wrote:

"Dave Peterson" wrote:

Shouldn't you be saving that file as personal.xlsb

http://www.rondebruin.nl/personal.htm
(from Ron de Bruin's site)

Marcela wrote: Hi Dave and thank you - so should i re save the personal file? i still have some old macros that i use in that format personal.xls - also this issie came up 2-3 weeks ago - i have been running Office 2007 for the past 6 months on vista and never seen this error message. and which is wierd as well - all my macros created in xlsx file format are gone.. all at once 2-3 week ago, thank you


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?? // will come up everytime new excel file is opened or xlsx file
type is open. recently reinstalled Office 2007 - it didn't fixed this issue -
any sugestions?

--

Dave Peterson


--

Dave Peterson