Link Data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Andibevan" <andibevan@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 19 May 2005 17:47:56 +0100

Hi All,

I have a table in a spreadsheet with a large amount of data in it.

I then have a metrics page that calculates about 200 statistical
calculations.

I would like to seperate the metrics sheet from the main page as when I
update the data, it has to recalculate the metrics page for each change.

What is the best way to seperate the metrics page (I have considered turning
on / off re-calculation but this is not acceptable).

The metrics page utilises dynamic ranges and the name of the data file
changes daily.

I can think of a number of ways to do it but am sure that one is
significantly better than the others - any pointers would be appreciated.

Ta

Andi

.

Follow-Ups:
- Re: Link Data
  - From: PC
- RE: Link Data
  - From: Jamie A Miller

Prev by Date: RE: Formula: Date plus 3 months
Next by Date: What is an automatic way to delete all rows of a certain kind
Previous by thread: Formula: Date plus 3 months
Next by thread: RE: Link Data
Index(es):
- Date
- Thread

Relevant Pages

Re: Link Data
... pasting but thanks for the suggestion. ... If you separate the files and need to change the link reference you should ... > I would like to seperate the metrics sheet from the main page as when I ...
(microsoft.public.excel.misc)
Re: Link Data
... If you separate the files and need to change the link reference you should ... Edit/Links and then select the new file. ... > I would like to seperate the metrics sheet from the main page as when I ...
(microsoft.public.excel.misc)
RE: Link Data
... If you never want to have the formulas update, why not get rid of them. ... can copy all the data on the metrics page and then right click and choose ... > I would like to seperate the metrics sheet from the main page as when I ...
(microsoft.public.excel.misc)
Re: Boeing and metrcication question
... That's fine if you're doing calculations involving joules and motor output, ... they often are more practical for ordinary measurements. ... Even where metrics stand up well in those every-day measurements, ... scientists in various specialties everywhere, we don't always prefer the SI ...
(rec.crafts.metalworking)
Re: [fw-wiz] Re: Flawed Surveys [was: VPN endpoints] (Paul D. Robertson)
... I think "what metrics would we like to see" is a good starting question. ... Amount of extortion by former employees. ... Paul D. Robertson "My statements in this message are personal opinions ...
(Firewall-Wizards)