Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto update worksheets
I have a workbook that contains multiple worksheets, one of the sheets is the
master sheet and I would like to know if anyone knows how you can set it up so that when you make changes in the master sheet, the other worksheets will automatically be updated? Haven't been able to figure it out. Any help would be much appreciated. -- J James |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto update worksheets
If you have Automatic calculation set (usually the default) and you have
formulae in those other worksheets which depend on values in the master sheet, then they will be updated automatically if you change a value in the master sheet. In those subsidiary sheets, you might have a formula like this: =master!A1 * 20% which will give you 20% of whatever is in cell A1 of the master sheet. The syntax for these linked formulae is: 'sheet name'!cell_reference Apostrophes are required if your sheet names have spaces in them. Hope this helps. Pete "J James" wrote in message ... I have a workbook that contains multiple worksheets, one of the sheets is the master sheet and I would like to know if anyone knows how you can set it up so that when you make changes in the master sheet, the other worksheets will automatically be updated? Haven't been able to figure it out. Any help would be much appreciated. -- J James |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto update worksheets
I unfortunately don't have formulas in the additional worksheets. Also,
where would I place a formula, what cell do I put it in? For example, I'm inserting rows, deleting rows, changing some of the information in the columns and I'm having to update each worksheet as well as the pivot tables that are associated with these worksheets. -- J James "Pete_UK" wrote: If you have Automatic calculation set (usually the default) and you have formulae in those other worksheets which depend on values in the master sheet, then they will be updated automatically if you change a value in the master sheet. In those subsidiary sheets, you might have a formula like this: =master!A1 * 20% which will give you 20% of whatever is in cell A1 of the master sheet. The syntax for these linked formulae is: 'sheet name'!cell_reference Apostrophes are required if your sheet names have spaces in them. Hope this helps. Pete "J James" wrote in message ... I have a workbook that contains multiple worksheets, one of the sheets is the master sheet and I would like to know if anyone knows how you can set it up so that when you make changes in the master sheet, the other worksheets will automatically be updated? Haven't been able to figure it out. Any help would be much appreciated. -- J James |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto update worksheets
Well, I think you need to have a clearer idea of what it is you want to do.
If you had formulae then all that messing about with deleting and inserting rows and columns may screw them up anyway. It might be that a macro solution would be best - make the changes then click on a button to rebuild the sheets. But, you need to be able to say what it is that you want to achieve. Pete "J James" wrote in message ... I unfortunately don't have formulas in the additional worksheets. Also, where would I place a formula, what cell do I put it in? For example, I'm inserting rows, deleting rows, changing some of the information in the columns and I'm having to update each worksheet as well as the pivot tables that are associated with these worksheets. -- J James "Pete_UK" wrote: If you have Automatic calculation set (usually the default) and you have formulae in those other worksheets which depend on values in the master sheet, then they will be updated automatically if you change a value in the master sheet. In those subsidiary sheets, you might have a formula like this: =master!A1 * 20% which will give you 20% of whatever is in cell A1 of the master sheet. The syntax for these linked formulae is: 'sheet name'!cell_reference Apostrophes are required if your sheet names have spaces in them. Hope this helps. Pete "J James" wrote in message ... I have a workbook that contains multiple worksheets, one of the sheets is the master sheet and I would like to know if anyone knows how you can set it up so that when you make changes in the master sheet, the other worksheets will automatically be updated? Haven't been able to figure it out. Any help would be much appreciated. -- J James |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto update worksheets
I did say what I wanted to achieve and don't think that was an appropriate
response. -- J James "Pete_UK" wrote: Well, I think you need to have a clearer idea of what it is you want to do. If you had formulae then all that messing about with deleting and inserting rows and columns may screw them up anyway. It might be that a macro solution would be best - make the changes then click on a button to rebuild the sheets. But, you need to be able to say what it is that you want to achieve. Pete "J James" wrote in message ... I unfortunately don't have formulas in the additional worksheets. Also, where would I place a formula, what cell do I put it in? For example, I'm inserting rows, deleting rows, changing some of the information in the columns and I'm having to update each worksheet as well as the pivot tables that are associated with these worksheets. -- J James "Pete_UK" wrote: If you have Automatic calculation set (usually the default) and you have formulae in those other worksheets which depend on values in the master sheet, then they will be updated automatically if you change a value in the master sheet. In those subsidiary sheets, you might have a formula like this: =master!A1 * 20% which will give you 20% of whatever is in cell A1 of the master sheet. The syntax for these linked formulae is: 'sheet name'!cell_reference Apostrophes are required if your sheet names have spaces in them. Hope this helps. Pete "J James" wrote in message ... I have a workbook that contains multiple worksheets, one of the sheets is the master sheet and I would like to know if anyone knows how you can set it up so that when you make changes in the master sheet, the other worksheets will automatically be updated? Haven't been able to figure it out. Any help would be much appreciated. -- J James |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto update worksheets
No offence intended - perhaps someone else might be able to give you better
advice. Pete "J James" wrote in message ... I did say what I wanted to achieve and don't think that was an appropriate response. -- J James "Pete_UK" wrote: Well, I think you need to have a clearer idea of what it is you want to do. If you had formulae then all that messing about with deleting and inserting rows and columns may screw them up anyway. It might be that a macro solution would be best - make the changes then click on a button to rebuild the sheets. But, you need to be able to say what it is that you want to achieve. Pete "J James" wrote in message ... I unfortunately don't have formulas in the additional worksheets. Also, where would I place a formula, what cell do I put it in? For example, I'm inserting rows, deleting rows, changing some of the information in the columns and I'm having to update each worksheet as well as the pivot tables that are associated with these worksheets. -- J James "Pete_UK" wrote: If you have Automatic calculation set (usually the default) and you have formulae in those other worksheets which depend on values in the master sheet, then they will be updated automatically if you change a value in the master sheet. In those subsidiary sheets, you might have a formula like this: =master!A1 * 20% which will give you 20% of whatever is in cell A1 of the master sheet. The syntax for these linked formulae is: 'sheet name'!cell_reference Apostrophes are required if your sheet names have spaces in them. Hope this helps. Pete "J James" wrote in message ... I have a workbook that contains multiple worksheets, one of the sheets is the master sheet and I would like to know if anyone knows how you can set it up so that when you make changes in the master sheet, the other worksheets will automatically be updated? Haven't been able to figure it out. Any help would be much appreciated. -- J James |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto update worksheets
Life just isn't fair, is it James. To get free, accurate advice, all you
have to do is ask a clear question. If that's not something you can handle, then this group isn't for you. Regards, Fred. "J James" wrote in message ... I did say what I wanted to achieve and don't think that was an appropriate response. -- J James "Pete_UK" wrote: Well, I think you need to have a clearer idea of what it is you want to do. If you had formulae then all that messing about with deleting and inserting rows and columns may screw them up anyway. It might be that a macro solution would be best - make the changes then click on a button to rebuild the sheets. But, you need to be able to say what it is that you want to achieve. Pete "J James" wrote in message ... I unfortunately don't have formulas in the additional worksheets. Also, where would I place a formula, what cell do I put it in? For example, I'm inserting rows, deleting rows, changing some of the information in the columns and I'm having to update each worksheet as well as the pivot tables that are associated with these worksheets. -- J James "Pete_UK" wrote: If you have Automatic calculation set (usually the default) and you have formulae in those other worksheets which depend on values in the master sheet, then they will be updated automatically if you change a value in the master sheet. In those subsidiary sheets, you might have a formula like this: =master!A1 * 20% which will give you 20% of whatever is in cell A1 of the master sheet. The syntax for these linked formulae is: 'sheet name'!cell_reference Apostrophes are required if your sheet names have spaces in them. Hope this helps. Pete "J James" wrote in message ... I have a workbook that contains multiple worksheets, one of the sheets is the master sheet and I would like to know if anyone knows how you can set it up so that when you make changes in the master sheet, the other worksheets will automatically be updated? Haven't been able to figure it out. Any help would be much appreciated. -- J James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sometimes formuli in workbook don't auto update with auto-recal on | Excel Worksheet Functions | |||
Auto Update the formula values without opening the link worksheets | Excel Worksheet Functions | |||
Sharing data between worksheets (auto-update) | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
auto update | Excel Worksheet Functions |