Help Required - Disabling autoupdate command boxes

[5pds]

Can anyone help with the above, There is an auto update box that come up everytime i open my document and i am always clicking on dont update. Its beginning to get on my nerves actually.

Soulution?

Cheers

Paul

 

[mattaustin01]

Remove the links to the other workbook if you don't need them

 

[5pds]

How?

 

[jim may]

At the menu, Edit -- links...

 

[mattaustin01]

Somewhere in your workbook you will have cells that are referring to data from another workbook. The formulas in the cells will look something like:

='name of other workbook.xls'!$A$1

or

='C:\documents and settings\user\my document\other workbook.xls'!$A$1


If you're sure you don't need them then just delete the formulas, however if the cells are used then you may lose some of the functionality of your current spreadsheet. Maybe best to save a copy of it first, remove the links and see if it still functions correctly

 

[mattaustin01]

Or Jim's way would be quicker if you've a large workbook!

 

[Ivan F Moala]

How?

Xl2003 > Edit > Links
select [Break links]