Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path in formulas
Is there anyway to have Excel not put the path in a formula when renaming a
file. I have some large long IF statements in my workbook and when I save the file in a different directory and then try to reopen, I get a "formula is too long" error. These functions are linked to other spreadsheets on different drives. Can someone please help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path in formulas
Rob,
Sorry, but no. The way around this is to put each link into a separate cell, then make your formula using only those local cells. HTH, Bernie MS Excel MVP "Rob" wrote in message ... Is there anyway to have Excel not put the path in a formula when renaming a file. I have some large long IF statements in my workbook and when I save the file in a different directory and then try to reopen, I get a "formula is too long" error. These functions are linked to other spreadsheets on different drives. Can someone please help? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path in formulas
Bernie, could you put the references into a named-range...
RangeName: LogRange RefersTo: =[c:\documents and settings\myname\my documents\myOthersheet.xls]Logs!$A$1:$H$10 then the formulas would use the shorter name "LogRange" to represent that link? -- Regards, John "Bernie Deitrick" wrote: Rob, Sorry, but no. The way around this is to put each link into a separate cell, then make your formula using only those local cells. HTH, Bernie MS Excel MVP "Rob" wrote in message ... Is there anyway to have Excel not put the path in a formula when renaming a file. I have some large long IF statements in my workbook and when I save the file in a different directory and then try to reopen, I get a "formula is too long" error. These functions are linked to other spreadsheets on different drives. Can someone please help? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path in formulas
John,
I don't know, because I personally prefer to not use complex names. I think they make it harder to understand a workbook and maintain it. But it may work, though I would certainly test to see what happens when the "myOthersheet" file is saved under a different name. Bernie MS Excel MVP "John Keith" wrote in message ... Bernie, could you put the references into a named-range... RangeName: LogRange RefersTo: =[c:\documents and settings\myname\my documents\myOthersheet.xls]Logs!$A$1:$H$10 then the formulas would use the shorter name "LogRange" to represent that link? -- Regards, John "Bernie Deitrick" wrote: Rob, Sorry, but no. The way around this is to put each link into a separate cell, then make your formula using only those local cells. HTH, Bernie MS Excel MVP "Rob" wrote in message ... Is there anyway to have Excel not put the path in a formula when renaming a file. I have some large long IF statements in my workbook and when I save the file in a different directory and then try to reopen, I get a "formula is too long" error. These functions are linked to other spreadsheets on different drives. Can someone please help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel changing Path of Formulas | Excel Discussion (Misc queries) | |||
Advice long path names in formulas.... | Excel Worksheet Functions | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
Copying formulas to a different file without path in the formula? | Excel Worksheet Functions | |||
How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions |