Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking between worksheets | Excel Discussion (Misc queries) | |||
linking worksheets | New Users to Excel | |||
I am getting #VALUE! when linking worksheets - what am i doing wro | Excel Discussion (Misc queries) | |||
linking worksheets | Excel Worksheet Functions | |||
Linking worksheets | Excel Worksheet Functions |