If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|