Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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)
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,071
Default 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)



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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)




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,071
Default 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)






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking between worksheets mab1963 Excel Discussion (Misc queries) 5 October 26th 07 07:31 PM
linking worksheets bails New Users to Excel 3 July 13th 06 07:58 PM
I am getting #VALUE! when linking worksheets - what am i doing wro KAT Excel Discussion (Misc queries) 7 February 23rd 06 07:46 AM
linking worksheets Robin Block Excel Worksheet Functions 1 February 4th 06 10:37 PM
Linking worksheets Linking Blank Cells Excel Worksheet Functions 1 November 11th 05 05:23 PM


All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"