gordon3d
New Member
- Joined
- Mar 26, 2004
- Messages
- 37
Is there anyway of importing data from other Excel spreadsheets (scattered throughout the company network) efficiently and WITHOUT having to open these sources? I am at present utilising Import External Data function with "Update every 30minutes" and that this spreadsheet is always open. However, I get various errors of "cannot find ...etc" when the auto-update looks for sources that are not open but a few more clicks on the "Update Now", it then open these sources as"Read Only", updates but leaves the source spreadsheet open. Further auto-updates comes from these opened spreadsheets which has data that may not be current.
Idea: What I have to do is consolidate various data from various user's spreadsheet (and Access eventually), put them in a spreadsheet as a central spreadsheet that has calculated fields and from which various external generated reports can get its information.
Idea: What I have to do is consolidate various data from various user's spreadsheet (and Access eventually), put them in a spreadsheet as a central spreadsheet that has calculated fields and from which various external generated reports can get its information.