A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

make calculations work with one worksheet closed



 
 
Thread Tools Display Modes
  #1  
Old March 30th, 2010, 05:18 PM posted to microsoft.public.excel.newusers
Bob L[_2_]
external usenet poster
 
Posts: 9
Default make calculations work with one worksheet closed

Is it possible to make formulas work if only one worksheet is open? I am
trying to make some spreadsheets for an elderly person and I have to open
too many worksheets open for it to work. Lets say I have a worksheet
called Quarter. That sheet gets its information from a sheet called
Journal. Once the data is entered into the journal it gets transferred to
the Quarter sheet, but if I open up the Quarter sheet without the Journal
sheet open I just get value in the cells. Can I do something so that the
journal does not have to be opened and still get the info in the Quarter
sheet?

Ads
  #2  
Old March 30th, 2010, 05:39 PM posted to microsoft.public.excel.newusers
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default make calculations work with one worksheet closed

EXCEL 2007

Bob, I think the answer to that is no.

If you update the first Workbook without Worbook 2 being open it will not
populate across automatically.

However, if you update Worbook 1 without Workbook 2 being open when you do
open Workbook 2 you should get a Security Warning towards the top of the
EXCEL screen.

Click on Options . . . / select Enable this content and hit OK. This will
pull in any updates that may have been made in Workbook 1.

If my comments have helped please hit Yes.

Thanks.

"Bob L" wrote:

Is it possible to make formulas work if only one worksheet is open? I am
trying to make some spreadsheets for an elderly person and I have to open
too many worksheets open for it to work. Lets say I have a worksheet
called Quarter. That sheet gets its information from a sheet called
Journal. Once the data is entered into the journal it gets transferred to
the Quarter sheet, but if I open up the Quarter sheet without the Journal
sheet open I just get value in the cells. Can I do something so that the
journal does not have to be opened and still get the info in the Quarter
sheet?

  #3  
Old March 30th, 2010, 06:18 PM posted to microsoft.public.excel.newusers
Bob L[_2_]
external usenet poster
 
Posts: 9
Default make calculations work with one worksheet closed

I have a couple of workbooks at work that seem to do this. I enter data
into workbook 1 and save and close. I open up workbook 2 and the data is
there. Both files are on what we call the R drive, which is a networked
drive. Maybe because it is on a network drive?

"trip_to_tokyo" wrote in message
...
EXCEL 2007

Bob, I think the answer to that is no.

If you update the first Workbook without Worbook 2 being open it will not
populate across automatically.

However, if you update Worbook 1 without Workbook 2 being open when you do
open Workbook 2 you should get a Security Warning towards the top of the
EXCEL screen.

Click on Options . . . / select Enable this content and hit OK. This will
pull in any updates that may have been made in Workbook 1.

If my comments have helped please hit Yes.

Thanks.

"Bob L" wrote:

Is it possible to make formulas work if only one worksheet is open? I am
trying to make some spreadsheets for an elderly person and I have to open
too many worksheets open for it to work. Lets say I have a worksheet
called Quarter. That sheet gets its information from a sheet called
Journal. Once the data is entered into the journal it gets transferred
to
the Quarter sheet, but if I open up the Quarter sheet without the Journal
sheet open I just get value in the cells. Can I do something so that the
journal does not have to be opened and still get the info in the Quarter
sheet?

  #4  
Old March 30th, 2010, 06:34 PM posted to microsoft.public.excel.newusers
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default make calculations work with one worksheet closed

Somebody somewhere in your organization seems to have allowed the automatic
update of the linked Workbooks.

If they are both on the same drive it would make things easier.

"Bob L" wrote:

I have a couple of workbooks at work that seem to do this. I enter data
into workbook 1 and save and close. I open up workbook 2 and the data is
there. Both files are on what we call the R drive, which is a networked
drive. Maybe because it is on a network drive?

"trip_to_tokyo" wrote in message
...
EXCEL 2007

Bob, I think the answer to that is no.

If you update the first Workbook without Worbook 2 being open it will not
populate across automatically.

However, if you update Worbook 1 without Workbook 2 being open when you do
open Workbook 2 you should get a Security Warning towards the top of the
EXCEL screen.

Click on Options . . . / select Enable this content and hit OK. This will
pull in any updates that may have been made in Workbook 1.

If my comments have helped please hit Yes.

Thanks.

"Bob L" wrote:

Is it possible to make formulas work if only one worksheet is open? I am
trying to make some spreadsheets for an elderly person and I have to open
too many worksheets open for it to work. Lets say I have a worksheet
called Quarter. That sheet gets its information from a sheet called
Journal. Once the data is entered into the journal it gets transferred
to
the Quarter sheet, but if I open up the Quarter sheet without the Journal
sheet open I just get value in the cells. Can I do something so that the
journal does not have to be opened and still get the info in the Quarter
sheet?

  #5  
Old March 30th, 2010, 08:22 PM posted to microsoft.public.excel.newusers
Bob L[_2_]
external usenet poster
 
Posts: 9
Default make calculations work with one worksheet closed

So why won't it work since both are in my documents? I'm a little confused.

"trip_to_tokyo" wrote in message
...
Somebody somewhere in your organization seems to have allowed the
automatic
update of the linked Workbooks.

If they are both on the same drive it would make things easier.

"Bob L" wrote:

I have a couple of workbooks at work that seem to do this. I enter data
into workbook 1 and save and close. I open up workbook 2 and the data is
there. Both files are on what we call the R drive, which is a networked
drive. Maybe because it is on a network drive?

"trip_to_tokyo" wrote in message
...
EXCEL 2007

Bob, I think the answer to that is no.

If you update the first Workbook without Worbook 2 being open it will
not
populate across automatically.

However, if you update Worbook 1 without Workbook 2 being open when you
do
open Workbook 2 you should get a Security Warning towards the top of
the
EXCEL screen.

Click on Options . . . / select Enable this content and hit OK. This
will
pull in any updates that may have been made in Workbook 1.

If my comments have helped please hit Yes.

Thanks.

"Bob L" wrote:

Is it possible to make formulas work if only one worksheet is open? I
am
trying to make some spreadsheets for an elderly person and I have to
open
too many worksheets open for it to work. Lets say I have a worksheet
called Quarter. That sheet gets its information from a sheet called
Journal. Once the data is entered into the journal it gets
transferred
to
the Quarter sheet, but if I open up the Quarter sheet without the
Journal
sheet open I just get value in the cells. Can I do something so that
the
journal does not have to be opened and still get the info in the
Quarter
sheet?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.