Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Update Linking and Saving
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. |
#2
|
|||
|
|||
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 "Chewy" wrote: 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. |
#3
|
|||
|
|||
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 "Naz" wrote: 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 "Chewy" wrote: 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. |
#4
|
|||
|
|||
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. "Naz" wrote: 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 "Chewy" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|