Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How prevent formulas to get external references/path to current workbook?
Hi,
I have worksheets with a lot of different formulas, some pointing to named ranges, some to relative ranges and some to absolute ranges etc. Sometimes does the ranges in the formulas and named ranges become equipped with the path reference to the current workbook and also when I copy the cells from the workbook to another workbook, the formulas still point to the range into the earlier workbook. What rules is it regarding this matter, and how can I ensure the formulas AND named ranges always point to the workbook the formula current is within? I don't want to have external references. / Thank you for any support |
#2
|
|||
|
|||
if you copy formulas from one workbook to another workbook excel will retain
the original workbook name....you can edit each formula to make sure the workbook name refers t the workbook the formula is in or you can go to the edit menu then linksedit links then navigate back to your current workbook -- paul remove nospam for email addy! "Gunnar Johansson" wrote: Hi, I have worksheets with a lot of different formulas, some pointing to named ranges, some to relative ranges and some to absolute ranges etc. Sometimes does the ranges in the formulas and named ranges become equipped with the path reference to the current workbook and also when I copy the cells from the workbook to another workbook, the formulas still point to the range into the earlier workbook. What rules is it regarding this matter, and how can I ensure the formulas AND named ranges always point to the workbook the formula current is within? I don't want to have external references. / Thank you for any support |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |