Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Links do not recognize .xlsm extension
Good morning,
I have a worksheet that has links to a file called JAN.xls If someone saves the Jan file as a 2007 excel file which places the extension .xlsm instead of .xls, my links don't work. Is there some way to change the formula so that it works with all excel extensions? eg. doesn't matter if the JAN.xls file is saved as .xls .xlsm and so on? Thank you in advance. -Bad |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Links do not recognize .xlsm extension
Hey Bad,
I am assuming you get a #REF error. You can put in an if formula: =if(iserror([Jan.xls]Sheet1!A1),[Jan.xlsm]Sheet1!A1,[Jan.xls]Sheet1!A1) Rename Sheet1 to your sheet name. Drag it everywhere. Squeaky "BadBoy" wrote: Good morning, I have a worksheet that has links to a file called JAN.xls If someone saves the Jan file as a 2007 excel file which places the extension .xlsm instead of .xls, my links don't work. Is there some way to change the formula so that it works with all excel extensions? eg. doesn't matter if the JAN.xls file is saved as .xls .xlsm and so on? Thank you in advance. -Bad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Personal.xlsm | Excel Discussion (Misc queries) | |||
what is xlsm' file | Excel Discussion (Misc queries) | |||
What does the extension '.xlsm' mean | Excel Discussion (Misc queries) | |||
Excel 2007 xlsm and worksheet links not updatings | Excel Discussion (Misc queries) | |||
Transformation d'images avec une extension .jpg ou .jpeg en images avec extension .bmp ou .ico | Excel Discussion (Misc queries) |