Stop Excel's UPDATE\Don't UPDATE message box from appearing every time I open the work book
 

I had moved a sheet from one workbook to another,lets say A to B.Now
whenevr I open this second workbook B a dialogbox opens up asking do u
want to update \Don't update the links.What do I do so that such a
thing doesn't happen evry time I open a workbook??

regards
Divya

Stop Excel's UPDATE\Don't UPDATE message box from appearing every time I open the work book
 

Divya,
EditLinksUpdate: Manual.

NickHK

"divya" wrote in message
ups.com...
I had moved a sheet from one workbook to another,lets say A to B.Now
whenevr I open this second workbook B a dialogbox opens up asking do u
want to update \Don't update the links.What do I do so that such a
thing doesn't happen evry time I open a workbook??

regards
Divya

Stop Excel's UPDATE\Don't UPDATE message box from appearing every time I open the work book
 

NickHK wrote:
Divya,
EditLinksUpdate: Manual.

NickHK

"divya" wrote in message
ups.com...
I had moved a sheet from one workbook to another,lets say A to B.Now
whenevr I open this second workbook B a dialogbox opens up asking do u
want to update \Don't update the links.What do I do so that such a
thing doesn't happen evry time I open a workbook??

regards
Divya

thanks a lot,Actually new to VBA programming so am not familiar with
all the stuff.
regards
Divya

Stop Excel's UPDATE\Don't UPDATE message box from appearing everytime I open the work book
 

can u tell me how can i save excel every second with out warning