Referencing a workbook

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
2,038
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Do you need to have a workbook open to reference it? I have a workbook that is used like a calculator for generating quotes and I need to be able to update prices in another workbook. Do I need to have code to open the workbook containing the calculator in order use it to get the new price?
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Lee J

New Member
Joined
Jun 30, 2020
Messages
45
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
In reality no, Lets say you have a workbook called BookX and you want to use the value from cell A1 in BookZ the formula would be:

='C:\Users\?????????\Desktop\[BookX.xlsx]Sheet1'!$A$1

If it was located on your desktop with the ? replaced with your computer username, on entering the formula it would get the value from BookX and then close the workbook - so fast you can't see it.

Then every time you open BookZ it will ask about updating the value but again will be so quick you can't see it
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,917
If the other workbook is going to do anything, like calculate formulas, it will need to be opened.

If you just want to read a value that is in the workbook, you can do that with the workbook closed.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,139
Messages
5,599,951
Members
414,350
Latest member
ajesh27

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top