TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
A colleague has to run a report that will regularly pull in data from other
sources and place it into an Excel spreadsheet. Can anyone give us
instructions for setting up an "update" macro in the spreadsheet so that it
will refresh the data automatically when it is opened?
(We could set it up so that the users press an "update data" button after
they open the spreadsheet, but if it can be set to do it automatically, that
would be much cleaner and reduce the error margin.)