Reading a Value from a Closed Excel File ?

[Flourgrader]

Hi Guys
Can someone help me out please?
I am a novice with excel so please spell it out
In very simple terms.
I want to open an Excel spreadsheet X:\EXCEL\Pension.xlsx
And I want CELL G14 to read a value stored in another CLOSED
Excel spreadsheet X:\EXCEL\costs.xlsx CELL E4
CELL E4 holds a value of £10,000 at the moment,it will change !
I want to take that away from X:\EXCEL\Pension.xlsx G14
Hope that makes sense
Thanks a lot Guys

 

[Scott T]

When you link to an cell in the external file the file will ask if you want to update the links.

 

[Flourgrader]

I don't understand what you mean Scott??
If you understand my Question .
Will you give me an example of how I enter it into excel spreadsheet cell from the info I have submitted ?

 

[Scott T]

When you enter a cell reference to an external workbook youget something like
='X:\EXCEL\[costs.xlsx]Sheet1'!$G$14
Open both files and hit = and then select the cell in theother file.
What happens when you open the file again depends on yoursettings it can update automatically, or to be promoted to update.
https://support.office.com/en-us/ar...-updated-21e995b5-bab1-4328-8ab3-dd357fe0e653

 

[Flourgrader]

Thanks Scott,
I well appreciated the advice.
I'll give that a go.

 

[Flourgrader]

Thanks again Scott.
I have given it a go and
It works just like you explained.
and the link was of a great assistance.

 

[Scott T]

You're welcome