ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   absolute reference to workbooks (https://www.excelbanter.com/excel-worksheet-functions/157362-absolute-reference-workbooks.html)

TKoel

absolute reference to workbooks
 
What is the syntax to referring to another worksheet in a specific
folder/directory with an absolute referrence?
I frequently save-as the referneced workbooks and the calling workbook
updates the formulas to the new saved-as name. I want it to continually
refer to the original name.

Thanks.


All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com