Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error 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?? // 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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message
Shouldn't you be saving that file as personal.xlsb
http://www.rondebruin.nl/personal.htm (from Ron de Bruin's site) Marcela wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message
"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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message
"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: o hi again, forgot to say that i have both office 2003 & 7 due other application that can run only as office 2003 :(, 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message
Hi Marcela
all my macros created in xlsx file format are gone That's correct In this file format all macros will be deleted from your file xlsm is the format with macros I suggest this Rename the Personal.xls with your code to myoldpersonal.xls Creat a new Personal file (see my site) Open myoldpersonal.xls When you go to the VBA editor you see both workbooks now Drag and drop the modules from myoldpersonal.xls to the new Persnoal file -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Marcela" wrote in message ... "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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message
FWIW, I have one Personal.xls that I use with Excel 2000, 2002, 2003 and
2007. It works fine and Excel 2007 never gives me a message like you're getting. -- Jim "Marcela" wrote in message ... | | | "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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Message | Excel Discussion (Misc queries) | |||
VBA Error Message "Compile Error...." | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
Error Message | Excel Discussion (Misc queries) |