• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

links to a column removed after column changed

D

Dubs

New Member
Hi folks, I don't know how to ask the exact question.

Code: 
        B              C              D            E
1   Dec-2013      Nov-2014       Dec-2014
2      39.1            44.0            45.6
3     3.2              3.8              3.4
4     7.6%            8.0%          6.9%
5      54.1%          58.3%        59.6%
6      17.9%          14.3%        14.3%
Sheet 1

Columns B, C and D all link to another master document without issue.
If I copy column D and paste it to E I get the Jan 2015 data from my master.
I then delete column D and E now becomes D.

My issue is in another sheet called 'temp' I further summarise Sheet 1 by linking to cells like =sheet1!D2 and the link now shows #REF after the copy paste in Sheet1.

Is there a fix for this please?

Thanks.
 
Hi ,

The link formula shows an error value because you have deleted column D ; do you really mean that you delete column D , or are you only clearing the contents of the column by selecting the column and pressing the DEL key ?

What is it that you want to achieve ? Can you describe the entire process ?

Narayan
 
in effect you are correct, I am deleting column D where the links point to.
but, column E then shows as column D and the links do not readjust to the ''mew' column D
 
Hi ,

That is not the way Excel works ; when you delete a column or a row , obviously Excel cannot leave a vacuum ; if you delete the column D , Excel cannot maintain the worksheet so that after column C , the next column becomes column E.

Excel will automatically rearrange cells / rows / columns / tabs whenever you delete them. Suppose you delete rows 1 through 5 ; Excel will automatically shift the remaining rows upwards , so that what was row 6 will now be row 1 , what was row 7 will now be row 2 and so on.

Never delete cells / rows / columns / tabs if there are formulae which refer to them ; all of the formulae will display error values , and it may be impossible to revert unless you use the Undo feature immediately. As an example , if you do carry out such an action and then save the workbook , all records of the formulae are lost.

Narayan
 
You must log in or register to reply here.
Back
Top