My links become #value! when I insert a row
 

My links in my worksheet become #value! when I insert a row/column. Help!

If I understand your problem correctly:-

The #VALUE! appears on cells when it's content is too wide for the
column width. Try increasing the size of the column so that the actual
value can fit. Double Click the line to the right of the column letter
at the top of the worksheet (the left border of what looks like the
button for each column label) and it will automatically resize the
column. If not just resize it to whatever size you want.


--
jaydevil
------------------------------------------------------------------------
jaydevil's Profile: http://www.excelforum.com/member.php...o&userid=26672
View this thread: http://www.excelforum.com/showthread...hreadid=399677

Another possibility is that the links themselves may not be adjusting to
accomodate the new rows or columns.

Check that the links are O.K. after s sample insertion
--
Gary's Student


"Renee L at the Club" wrote:

My links in my worksheet become #value! when I insert a row/column. Help!

I've seen the display change to ########'s when the column wasn't wide enough.
I don't think I've ever seen #value! show up for this.

Are you sure you have?

jaydevil wrote:

If I understand your problem correctly:-

The #VALUE! appears on cells when it's content is too wide for the
column width. Try increasing the size of the column so that the actual
value can fit. Double Click the line to the right of the column letter
at the top of the worksheet (the left border of what looks like the
button for each column label) and it will automatically resize the
column. If not just resize it to whatever size you want.

--
jaydevil
------------------------------------------------------------------------
jaydevil's Profile: http://www.excelforum.com/member.php...o&userid=26672
View this thread: http://www.excelforum.com/showthread...hreadid=399677

--

Dave Peterson

What do your formulas look like?

Renee L at the Club wrote:

My links in my worksheet become #value! when I insert a row/column. Help!

--

Dave Peterson

Care to give an example of the type of link you're talking about?

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"jaydevil" wrote in
message ...

If I understand your problem correctly:-

The #VALUE! appears on cells when it's content is too wide for the
column width. Try increasing the size of the column so that the actual
value can fit. Double Click the line to the right of the column letter
at the top of the worksheet (the left border of what looks like the
button for each column label) and it will automatically resize the
column. If not just resize it to whatever size you want.


--
jaydevil
------------------------------------------------------------------------
jaydevil's Profile:
http://www.excelforum.com/member.php...o&userid=26672
View this thread: http://www.excelforum.com/showthread...hreadid=399677

I have the same problem. I have found the only way to get the file to
display correctly is to have the source file open as well as the target file.
this is of course a major nuisance.
i have worked with Excel for many years, but I have only seen this error in
the last couple of months.

Sandy.


"Renee L at the Club" wrote:

My links in my worksheet become #value! when I insert a row/column. Help!

My links become #value! when I insert a row
 

How do you check the links??? I'm seeing the same problem when I adjust my
ranges. The source data is on a worksheet that is separate from macro, but
within the same workbook.

"Gary's Student" wrote:

Another possibility is that the links themselves may not be adjusting to
accomodate the new rows or columns.

Check that the links are O.K. after s sample insertion
--
Gary's Student


"Renee L at the Club" wrote:

My links in my worksheet become #value! when I insert a row/column. Help!