![]() |
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) |
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) |
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) |
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