automatically updating a summary worksheet

[Guest]

Hi,

I have several tabs (worksheets) representing purchases for a specific year.
There is one tab (worksheet) that is a Summary of all purchases for all
years. How do I get Excel to automatically update the Summary worksheet
anytime one of the other worksheets are modified?

 

[Ken Johnson]

Hi,
Search "Refer to the same cell or range on multiple sheets" in Help.
It clearly shows how to set up a 3D function so that changes are
automatically reflect in the Summary sheet
Ken Johnson

 

[Guest]

Excel by default calculate cells and worksheets automatically (after value in
cell is changed). There is also option to calculate manualy (using F9). To
change it go Tools/Option - there is tab "Calcualtion".

 

[Guest]

Ok, I'll check this out. Thank you for the help. It's one of those
situations where I'm managing software license purchases, so for instance, if
the 2006 worksheet adds two licenses of a specific title, I want the summary
worksheet to automatically update and add two to the specific title. Will
the 3D function work for this?
Steve P.

 

[Guest]

Ken,

I followed the instructions to set up a 3D function but ran into a problem.
Here's what I did.
Opened spreadsheet and clicked on summary tab.
Followed the instructions for a 3D function.
Typed = in the refers to box.
Clicked on the first tab and then held shift and clicked the last tab.
It then says to select the cell or range of cells to be referenced. I
selected all of the cells I wanted to reference on the summary tab. Is this
wrong?
Thanks,
Steve P.

 

[Ken Johnson]

Hi Steve,
I can see what's gone wrong.
The search result turns up with "Create named cell references or ranges
on multiple worksheets" at the top of the list (not the right one) and
"Refer to the same cell or range on multiple sheets" just below it
(this is the one you need).
You have accidentally followed the instructions for setting up a named
range.
Get into the one with the "Refer to the same cell or range on multiple
sheets" heading and see how you go with those instructions.

Good Luck

Ken Johnson