I am getting #VALUE! when linking worksheets - what am i doing wro

[Guest]

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,

 

[Biff]

Hi!

Post the complete formula that you're using.

Biff

 

[Guest]

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]

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]

Hi Biff,

Apologies i copied the actual formula from sheet 2 (named 00217) not the
formula that is showing up when i link sheet 2 to sheet 1 (called
the summary) the formula that is showing up in the linked (destination)
sheet is ='00217'!G23:G25 and that is where i keep getting the #VALUE!

When i say "linking" i mean in the destination cell (where i want the
info) i type = then i go to the cell in the other worksheet that has /
or will have the required info then press enter and the link is made.
I have not had this problem before and am confused as to how to fix it..
would it be easier if i attached the spreadsheet?

Thanks for you help.

KAT

 

[Guest]

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]

OK.........

='00217'!G23:G25

That's where you're getting the error. You're referencing a range of cells,
not a single cell.

If you want the sum of those cells:

=SUM('00217'!G23:G25)

If you want each individual value in its own cell: (vertically)

='00217'!G23

Copy down to get:

='00217'!G24
='00217'!G25

OR, select 3 cells then enter as an array: (vertical)

='00217'!G23:G25

Biff

 

[Biff]

Ah ha!

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

Biff