We have a spreadsheet that displays info fed from a second source spreadsheet. Currently, a person updates/changes info on the source spreadsheet them must go to the display computer spreadsheet and perform EDIT > LINKS > UPDATE NOW. "Automatic" is checked on the destination spreadsheet. Is there a way ( a macro?) to have the destination spreadsheet automatically link to the source and update itself hourly or every so many hours?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Auto update from source hourly
- Thread starter bassls
- Start date
Similar threads
- Question
