Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Gunnar Johansson
 
Posts: n/a
Default 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   Report Post  
paul
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array Formulas take waaaay too long... belly0fdesire Excel Worksheet Functions 7 August 8th 05 10:11 PM
Need Formulas for counting multiple conditions OrdOff Excel Worksheet Functions 4 July 3rd 05 06:12 PM
Help, Urgent Excel Formulas are not calculating maashoff Excel Discussion (Misc queries) 1 May 3rd 05 12:25 AM
Problem with named formula's nathan Excel Worksheet Functions 0 January 21st 05 05:07 PM
calculating formulas for all workbooks in a folder Chad Excel Worksheet Functions 3 November 13th 04 06:22 PM


All times are GMT +1. The time now is 06:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"