Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=cell("filename") in multiple places
Hello Experts,
What would be the workaround so that each tab in the workbook containing the formula =cell("filename") would have the correct tab name including full file name? It seems that this formula's limitation is that it can appear only once in the workbook. Even then, it doesn't update the tab name automatically. I've tried =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) but it, too, has the wrong tab name if this formula appears in multiple sheets. Thanks in advance, Ricky |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=cell("filename") in multiple places
Ricky, try this,
=CELL("filename",A1) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Ricky Pang" wrote in message ... Hello Experts, What would be the workaround so that each tab in the workbook containing the formula =cell("filename") would have the correct tab name including full file name? It seems that this formula's limitation is that it can appear only once in the workbook. Even then, it doesn't update the tab name automatically. I've tried =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) but it, too, has the wrong tab name if this formula appears in multiple sheets. Thanks in advance, Ricky |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=cell("filename") in multiple places
Thanks Paul,
Great. That's exactly what I needed. Thanks again, Ricky "Paul B" wrote in message ... Ricky, try this, =CELL("filename",A1) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Ricky Pang" wrote in message ... Hello Experts, What would be the workaround so that each tab in the workbook containing the formula =cell("filename") would have the correct tab name including full file name? It seems that this formula's limitation is that it can appear only once in the workbook. Even then, it doesn't update the tab name automatically. I've tried =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) but it, too, has the wrong tab name if this formula appears in multiple sheets. Thanks in advance, Ricky |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Parameter Query-enter just once for use in multiple places | Excel Discussion (Misc queries) |