Hi,
I have a large excel file that contains a lot of data that is used to drive other excel sheets. I currently use a query that pulls the information directly from the main data source but for this to work successfully, the main data source has to be open. Is there a better way to do this? Is there a formulae you can use to import full tables to another excel sheet? Or should an intermediate file be used that can be opened bu each user? As there is roughly 5000x14 cells of data, i worry that the transition will be slow.
Thanks,
Adam
Bookmarks