Have you experienced problems opening a link in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have this problem when we try to link another spreadsheet using excel
2003. What happen was when we open a spreadsheet which has a link to another
file using "SUMIF", "COUNTIF", "COUNTBLANK" it appears on the cell as #
VALUE. we would like to know whether this is an excel bug and what do we need
to do in order to solve this problem.
 
Marlon

The #Value error appears if the data you are referencing is not seen as a
calculable number. This normally means it is text, or seen as text. Check
the data is not formatted at text and also try re-entering some data after
you check formatting as this should enter it as a number and test the
theory.

If this is the case then you can 'bump' the text numbers to actual numbers
by copying an empty cell and then highlighting the data and selecting
Edit>Paste special...>values and add (This does nothing but makes Excel
realise they are numbers. Make sure there are no formulas during this
operation or they will be lost

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
Back
Top