| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stopping a workbook updating
Hi,
I have recently taken an existing workbook that had cells that updated from other workbooks. I have amended/removed all of these formulas, but whenever anyone opens the workbook it asks if you wish to 'update' the workbook. Is there a way of switching this feature off? Thanks, Bryan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stopping a workbook updating
There must still be links.
http://www.officearticles.com/excel/...soft_excel.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "Bryan" wrote in message ... Hi, I have recently taken an existing workbook that had cells that updated from other workbooks. I have amended/removed all of these formulas, but whenever anyone opens the workbook it asks if you wish to 'update' the workbook. Is there a way of switching this feature off? Thanks, Bryan |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stopping a workbook updating
Thanks Anne,
There was one link remaining - thank you for your help. Bryan "Anne Troy" wrote: There must still be links. http://www.officearticles.com/excel/...soft_excel.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "Bryan" wrote in message ... Hi, I have recently taken an existing workbook that had cells that updated from other workbooks. I have amended/removed all of these formulas, but whenever anyone opens the workbook it asks if you wish to 'update' the workbook. Is there a way of switching this feature off? Thanks, Bryan |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stopping a workbook updating
You're welcome. :)
So glad I could! ************ Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "Bryan" wrote in message ... Thanks Anne, There was one link remaining - thank you for your help. Bryan "Anne Troy" wrote: There must still be links. http://www.officearticles.com/excel/...soft_excel.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "Bryan" wrote in message ... Hi, I have recently taken an existing workbook that had cells that updated from other workbooks. I have amended/removed all of these formulas, but whenever anyone opens the workbook it asks if you wish to 'update' the workbook. Is there a way of switching this feature off? Thanks, Bryan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| Updating multiple worksheets in a large workbook | Excel Discussion (Misc queries) | |||
| Unprotect Workbook | Excel Discussion (Misc queries) | |||
| Updating links to new workbook with same format | Links and Linking in Excel | |||
Linear Mode
