Using Import External Data

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.
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
You can use External Data > new database query to set up similar imports which do not require the file to be opened to import the required data, nor to set up the query. Much like external links in formulas the query can refresh the file while the source file is closed. You have the same time-refresh options on a MS Query as you do on the Import External Data option.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,995
Messages
5,834,777
Members
430,321
Latest member
yemisimi11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top