Links between workbooks and keeping file sizes down

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steve - 08 Dec 2003 16:36 GMT

Hi! Can anyone help.

At the moment I am working on a Workbook which involves
measuring performance within an organisation.

There are 7 areas of measurement and 6 Geographical
regions to measure these by. The results are to be sent to
top management. These people dont need to see all the
calculations just the results.

Basically i wish to set up a workbook which involves all
the raw data for any calculations. I will link these to
the "viewers" workbook and, through calculations and
macros they will see the results measured.

Problem: i have been given the "viewers" workbook and i
wish to link it to this rough work workbook. this i want
to do without the need for the user to have to see this
rough work workbook. (i dont want absolute links to a file
but i do want to link in such a way that a change in the
rough work book will be shown in the "viewers" workbook

The "viewers" workbook will be emailed to all top managers

Reply to this Message

macropod - 17 Dec 2003 06:56 GMT

Hi Steve,

With the user workbooks, you'd probably do well to have a summary sheet that
brings together all of the data to be exported to the management workbook.
This makes any kind of inter-workbook linking easier to manage. In the
management workbook, you could use formulae in the required cells to pull in
data from each of the user workbooks. But, if you really want to keep the
size of the management workbook to a minimum, you might get something
smaller by using vba to import the data from the user workbooks. The vba
approach takes more work and, unless you're importing a lot of
well-structured data in blocks, might not save much - you may even end up
with a larger management workbook.

Cheers

> Hi! Can anyone help.
>
[quoted text clipped - 19 lines]
>
> The "viewers" workbook will be emailed to all top managers

Reply to this Message