ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Stopping a workbook updating (https://www.excelbanter.com/excel-discussion-misc-queries/71541-stopping-workbook-updating.html)

Bryan

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

Anne Troy

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




Bryan

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





Anne Troy

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








All times are GMT +1. The time now is 07:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com