Display Current Data from Several Spreadsheets?????????????

[infiniteMPG]

We have several Excel Spreadsheets that are all in the same network
location. These are all controlled and owned by different people.
What we'd like is a way to display all the spreadsheets together in
one document such as a Word document or even another Excel spreadsheet
so that someone can open this one document and see the current
contents of all the spreadsheets. This "master" document does not
need to do anything except be able to display the Excel spreadsheets
(current) all together but they do not need to be all one spreadsheet
or linked to each other in any way.

I have been able to insert Objects into a Word doc of the files but
they come in all messed up for how much of the spreadsheet is
displayed and I can't seem to get a handle on how to control the
zooming in the Object window. I can also insert an Excel Spreadsheet
in it's own little object window with scroll bars but I can't seem to
get this type of display for an existing Excel spreadsheet.

Can't see us as being the only people ever wanting to do this. We'd
be happy if it was even an HTML webpage people could call up (in fact
would really prefer that).

Any help?

 

[Ron de Bruin]

Hi

Try
http://www.rondebruin.nl/merge.htm

See also
http://msdn.microsoft.com/en-us/library/cc837974.aspx

 

[infiniteMPG]

Tryhttp://www.rondebruin.nl/merge.htm

See alsohttp://msdn.microsoft.com/en-us/library/cc837974.aspx

Those look interesting but we need a single document that when opened
will update the displayed info from the other spreadsheets and the
displayed info needs to update whenever the sub-spreadsheets are
updated. We don't need to just create a merged document, we need to
create a document that just displays the current other documents in
it. It needs to be a living document so anytime it's opened, the data
is reloaded and current.

 

[Ron de Bruin]

Use the Add-in or run the macro everytime you need the info
With formula links it is very diffecult to get all data from every workbook

What if you add or delete a workbook ?
How many rows of data are in every workbook ?

The Add-in or macro is much easier
When you need the data run the code or use the add-in