Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Consolidation question
Hi, I have three worksheets, set up identically. I created a fourth
worksheet which was to capture the totals of the other three. To do this, I used DataConsolidation and then put in the references to the sheets and ranges. No problem there. Now I am changing figures in the first three worksheets, but they are not filtering through to the consolidated sheets. Why? Any help would be appreciated. Many thanks. -- Trish |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Consolidation question
Hi again, further to my note below, I did go back to Data Consolidation and
I checked the update links box. However, the figures are not correct. Any suggestions? Thanks so much. -- Trish "Trish" wrote: Hi, I have three worksheets, set up identically. I created a fourth worksheet which was to capture the totals of the other three. To do this, I used DataConsolidation and then put in the references to the sheets and ranges. No problem there. Now I am changing figures in the first three worksheets, but they are not filtering through to the consolidated sheets. Why? Any help would be appreciated. Many thanks. -- Trish |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Consolidation question
All these postings ... it ooks as though I am talking to myself! Please
disregard earlier questions ... I think it is now okay. I should not have been so hasty! Many thanks. -- Trish "Trish" wrote: Hi again, further to my note below, I did go back to Data Consolidation and I checked the update links box. However, the figures are not correct. Any suggestions? Thanks so much. -- Trish "Trish" wrote: Hi, I have three worksheets, set up identically. I created a fourth worksheet which was to capture the totals of the other three. To do this, I used DataConsolidation and then put in the references to the sheets and ranges. No problem there. Now I am changing figures in the first three worksheets, but they are not filtering through to the consolidated sheets. Why? Any help would be appreciated. Many thanks. -- Trish |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Consolidation question
I'm new to this so be patient. I think I'm having the same challenge. When
I did the data consolidation, I selected Create Links, so I assume any new numbers I add or change should be transferred to the consolidated page. But what happens is that a total shows up in the last column, but the new numbers I've input on the linked worksheets that add up to that total DON'T show up. If this was your issue, can you tell me how you solved it? Thanks! "Trish" wrote: All these postings ... it ooks as though I am talking to myself! Please disregard earlier questions ... I think it is now okay. I should not have been so hasty! Many thanks. -- Trish "Trish" wrote: Hi again, further to my note below, I did go back to Data Consolidation and I checked the update links box. However, the figures are not correct. Any suggestions? Thanks so much. -- Trish "Trish" wrote: Hi, I have three worksheets, set up identically. I created a fourth worksheet which was to capture the totals of the other three. To do this, I used DataConsolidation and then put in the references to the sheets and ranges. No problem there. Now I am changing figures in the first three worksheets, but they are not filtering through to the consolidated sheets. Why? Any help would be appreciated. Many thanks. -- Trish |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Consolidation question
Hi Laronda. I don't think I know enough to be able to help you. It might be
an idea to post your questions as a new posting, so that it is near the top and will get expert attention! Best of luck :-) -- Trish "LARONDA" wrote: I'm new to this so be patient. I think I'm having the same challenge. When I did the data consolidation, I selected Create Links, so I assume any new numbers I add or change should be transferred to the consolidated page. But what happens is that a total shows up in the last column, but the new numbers I've input on the linked worksheets that add up to that total DON'T show up. If this was your issue, can you tell me how you solved it? Thanks! "Trish" wrote: All these postings ... it ooks as though I am talking to myself! Please disregard earlier questions ... I think it is now okay. I should not have been so hasty! Many thanks. -- Trish "Trish" wrote: Hi again, further to my note below, I did go back to Data Consolidation and I checked the update links box. However, the figures are not correct. Any suggestions? Thanks so much. -- Trish "Trish" wrote: Hi, I have three worksheets, set up identically. I created a fourth worksheet which was to capture the totals of the other three. To do this, I used DataConsolidation and then put in the references to the sheets and ranges. No problem there. Now I am changing figures in the first three worksheets, but they are not filtering through to the consolidated sheets. Why? Any help would be appreciated. Many thanks. -- Trish |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two question about Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 Question | Excel Discussion (Misc queries) | |||
Excel 2007 question? | Excel Worksheet Functions | |||
Further Question about Pivot Tables - Multiple Consolidation Range | Excel Discussion (Misc queries) | |||
New Data Consolidation Question | Excel Worksheet Functions |