ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Linking my worksheets (https://www.excelbanter.com/excel-worksheet-functions/189099-linking-my-worksheets.html)

DebbieK

Linking my worksheets
 
I am trying to link my worksheets and it was working and then after I saved
it and reopened it the next day it doesn't seem to be working now but the
formulas are still there but when I enter new information it's not being
reflected on the other sheets. I'm assuming that I'm missing a command??

My first sheet is called Registration and that's where I enter my main
information and then the sheets following are supposed to build from my main
registration sheet but now when I change a name it does not change on the
following work sheets. For example:

This is sheet 2 and it's referencing my registration page
=(Registration!B13&" "&Registration!A13&", "&Registration!C13)

Otto Moehrbach[_2_]

Linking my worksheets
 
Go to Tools - Options - Calculation tab. Is Calculation set to Manual?
Change it to Automatic. HTH Otto
"Debbiek" wrote in message
...
I am trying to link my worksheets and it was working and then after I saved
it and reopened it the next day it doesn't seem to be working now but the
formulas are still there but when I enter new information it's not being
reflected on the other sheets. I'm assuming that I'm missing a command??

My first sheet is called Registration and that's where I enter my main
information and then the sheets following are supposed to build from my
main
registration sheet but now when I change a name it does not change on the
following work sheets. For example:

This is sheet 2 and it's referencing my registration page
=(Registration!B13&" "&Registration!A13&", "&Registration!C13)




DebbieK

Linking my worksheets
 
Yes, it is set on "Automatic" already.

"Otto Moehrbach" wrote:

Go to Tools - Options - Calculation tab. Is Calculation set to Manual?
Change it to Automatic. HTH Otto
"Debbiek" wrote in message
...
I am trying to link my worksheets and it was working and then after I saved
it and reopened it the next day it doesn't seem to be working now but the
formulas are still there but when I enter new information it's not being
reflected on the other sheets. I'm assuming that I'm missing a command??

My first sheet is called Registration and that's where I enter my main
information and then the sheets following are supposed to build from my
main
registration sheet but now when I change a name it does not change on the
following work sheets. For example:

This is sheet 2 and it's referencing my registration page
=(Registration!B13&" "&Registration!A13&", "&Registration!C13)





Otto Moehrbach[_2_]

Linking my worksheets
 
Write a simple formula in some empty cell, something like =A1 and see if it
updates when you change A1. Otto
"Debbiek" wrote in message
...
Yes, it is set on "Automatic" already.

"Otto Moehrbach" wrote:

Go to Tools - Options - Calculation tab. Is Calculation set to Manual?
Change it to Automatic. HTH Otto
"Debbiek" wrote in message
...
I am trying to link my worksheets and it was working and then after I
saved
it and reopened it the next day it doesn't seem to be working now but
the
formulas are still there but when I enter new information it's not
being
reflected on the other sheets. I'm assuming that I'm missing a
command??

My first sheet is called Registration and that's where I enter my main
information and then the sheets following are supposed to build from my
main
registration sheet but now when I change a name it does not change on
the
following work sheets. For example:

This is sheet 2 and it's referencing my registration page
=(Registration!B13&" "&Registration!A13&", "&Registration!C13)








All times are GMT +1. The time now is 11:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com