Home |
Search |
Today's Posts |
#1
|
|||
|
|||
My links become #value! when I insert a row
My links in my worksheet become #value! when I insert a row/column. Help!
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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! |
#8
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reoccurring Edit Links Error | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
insert picture | Excel Discussion (Misc queries) | |||
Make excel insert links | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel |