K KiKi Member Aug 4, 2015 #1 Is there process to automate excel refresh part so that every month it's refreshed automatically and saved as new file or within same file?
Is there process to automate excel refresh part so that every month it's refreshed automatically and saved as new file or within same file?
Hui Excel Ninja Staff member Aug 5, 2015 #2 Kiki There are a number of ways of adding data to worksheets, including Manually, DB Queries, Linked files etc By refreshing you could mean simply adding a new row to a table and updating charts or a full re-import of the data or something in between You may be best to post a sample file and explain what you mean by refreshed?
Kiki There are a number of ways of adding data to worksheets, including Manually, DB Queries, Linked files etc By refreshing you could mean simply adding a new row to a table and updating charts or a full re-import of the data or something in between You may be best to post a sample file and explain what you mean by refreshed?