Ah ha!

Those merged cells are more trouble than they're worth!

Biff

"KAT" wrote in message
...
Hi Biff,

I have solved it - the source cell was a merged cell and the merge was
compromising the link process. Thanks for your help.

KAT

"Biff" wrote:

Hi!

If this formula:

=SUM(G23:G25)

is on Sheet2 in cell A1 and retunrs a valid result, then:

=Sheet2!A1

should also return the same valid result.

When you say "linking", what exactly does that mean?

=Sheet2!A1 is considered a link.

Biff

"KAT" wrote in message
...
The foruma i am using in the purchase order spreadsheets is eg:
=SUM(G23:G25)
for the totals column and when i go from the summary sheet to link it
to
this
total cell it comes up with the value error.

Thanks
Kat

"Biff" wrote:

Hi!

Post the complete formula that you're using.

Biff

"KAT" wrote in message
...
Using Excel 2002 - I have a workbook with a summary page and I link
the
totals from the other worksheets *numbered purchase orders and
wanted
the
summary to show just the totals - Net, Tax, Total. When i link these
from
the
summary to the individual worksheets i keep getting #VALUE! - the
forumla
i
am using in the purchase order worksheets is SUM is this the wrong
formula
to
be using. Any advice would be appreciated.

THanks,