| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic update formula when worksheet 1 move to another excel fi
I have 25 worksheets on excel 1. I decided to shift the first 10 worksheet to
another excel file (excel 2). But on excel 1, I have a summary page with formula from some of the worksheet file. Is any way that the summary page will update if I move the first 10 worksheet from excel 1 to excel 2? -- Thank You Bob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic update formula when worksheet 1 move to another excel fi
XL should rebuild the existing links as you move the sheets.
Just try 1 and see what happens. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bob Ng Kai Sin" wrote in message ... I have 25 worksheets on excel 1. I decided to shift the first 10 worksheet to another excel file (excel 2). But on excel 1, I have a summary page with formula from some of the worksheet file. Is any way that the summary page will update if I move the first 10 worksheet from excel 1 to excel 2? -- Thank You Bob |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic update formula when worksheet 1 move to another excel fi
Thank you V much RD, it work.
-- Thank You Bob "Bob Ng Kai Sin" wrote: I have 25 worksheets on excel 1. I decided to shift the first 10 worksheet to another excel file (excel 2). But on excel 1, I have a summary page with formula from some of the worksheet file. Is any way that the summary page will update if I move the first 10 worksheet from excel 1 to excel 2? -- Thank You Bob |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic update formula when worksheet 1 move to another excel fi
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bob Ng Kai Sin" wrote in message ... Thank you V much RD, it work. -- Thank You Bob "Bob Ng Kai Sin" wrote: I have 25 worksheets on excel 1. I decided to shift the first 10 worksheet to another excel file (excel 2). But on excel 1, I have a summary page with formula from some of the worksheet file. Is any way that the summary page will update if I move the first 10 worksheet from excel 1 to excel 2? -- Thank You Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i set up an automatic "date update" in excel? | New Users to Excel | |||
| Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
| Need to update information from one worksheet to another automatic | Excel Worksheet Functions | |||
| Automatic Update from Access to EXcel | Excel Discussion (Misc queries) | |||
| Automatic update of list in Excel | Excel Worksheet Functions | |||
Linear Mode
