| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update
Is there any way to update a workbook (which is getting data from
another workbook) without shutting it down, opening it again and clicking 'Yes' to the update question in the message box every time? Tried F9, doesn't seem to work. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update
Try selecting Edit Links... Make sure the correct source is selected,
then click 'Update Values'. Hope this helps, Hutch "robzrob" wrote: Is there any way to update a workbook (which is getting data from another workbook) without shutting it down, opening it again and clicking 'Yes' to the update question in the message box every time? Tried F9, doesn't seem to work. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update
On Jun 16, 9:30*pm, Tom Hutchins
wrote: Try selecting Edit Links... *Make sure the correct source is selected, then click 'Update Values'. Hope this helps, Hutch "robzrob" wrote: Is there any way to update a workbook (which is getting data from another workbook) without shutting it down, opening it again and clicking 'Yes' to the update question in the message box every time? Tried F9, doesn't seem to work.- Hide quoted text - - Show quoted text - Thanks, Hutch, I've put it in a macro. Perfect. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
| UPDATE - HELP | Links and Linking in Excel | |||
| i want to update one excel file the other one update automaticaly | New Users to Excel | |||
| keep value from last update and don't ask to update links | Excel Discussion (Misc queries) | |||
| Update / don't update dialog box | Excel Worksheet Functions | |||
Linear Mode
