Auto Update Linking and Saving

C

Chewy

G'day,

I have two spreedsheets which are linked and I am asked everytime I open
them to update the values. Do I have to have this box pop up. Also, if I
forget to save the document the updated values are not saved. Is there an
autosave for everytime the values are updated.

Thx.
 
N

Naz

If you are using Excel XP or 2003, you can set the start-up prompt to
" Don't display the alert and update links "
By clicking Edit then Links, then in the links box in the bottom left is a
start up prompt button.
Unfortunalety you can not do this in Excel 95/97/or 2000.
As for autosaving once the value are updated, i'm afraid I don't think that
is possible, unless you create a before close macro.


Hope that helps

_______________________
Naz
London
 
S

Sam

Is there any other way, with a macro for example, that this can be
accomplished?
I have a powerpoint presentation that is linked to number of Excel sheets
that are in turn linked to other workbooks. When I update the powerpoint
presentation, it prompts me to update each and every excel worksheet -
driving me crazy. I would like to not have to be promted to update each
excel sheet from powerpoint.

Thanks,
Sam
 
S

Sam

In 2000, in tools->options->edit, there is the option to ask for updates.
uncheck it and your sheets will update automatically. This will apply to
all excel files.
 
Top