Referencing cells in another workbook error

Combat Womble

New Member
Joined
Nov 18, 2015
Messages
30
Hello

I have a workbook that recives data from an external source (WB01). I am trying to create another workbook (WB02) that looks at certain cells in WB01, as the data in WB01 changes then the this is reflected in WB02.

I have both workbooks open and they are in the same folder (I have no idea if this makes a difference, but, when your grasping at straws ...).

If a go to cell A1 in WB02 and press =, and then go to WB01 and select a cell, there is no reference created in WB02.

I've searched around and found this :
Excel Formula:
=INDIRECT("'[sample data.xlsx]Sheet1'!A1")
from this website. Then I tried this I got #REF!. On Help with the error I get the following message "Your organization's administrator turned off the service required to use this feature".

This is my personal laptop with my personal files amd I cannot find out how to turn on the service required (The message doesn't even tell me the name of the service :( )

Please can you give a kick in the right direction.

Combat Womble
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,950
Office Version
  1. 365
Platform
  1. Windows

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,252
Office Version
  1. 365
Platform
  1. Windows
Why not just use
Excel Formula:
='[sample data.xlsx]Sheet1'!A1
 
Solution

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,950
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Are they both open in the same Excel session, or different Excel sessions?
If they are in different Excel sessions, they will not be able to see one another.

If you opened the files from Windows Explorer, they are porbably in different Excel sessions.
If you opened one file, and then open the second by going to File Open... in Excel and open it that way, they are probably both in the same Excel session.
 

Combat Womble

New Member
Joined
Nov 18, 2015
Messages
30
Fluff - Perfect ti mon doe! Works perfectly.
Joe4 - Thanks for that info. I had opened WB02 by File open, but I didn't know about excel seesions - I think you've saved me hours of headaches!

Combat Womble
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,252
Office Version
  1. 365
Platform
  1. Windows
Glad we could help & thanks for the feedback.
 

Forum statistics

Threads
1,141,060
Messages
5,704,041
Members
421,324
Latest member
Devo182

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