Error in formula link

[saajscaria]

Good day!!

I have a worksheet which has around 100 sheets. this assignment has full of links and formulas. Sometimes, when I put a link from one cell to another cell the value of the original cell is not displaying in the destination cell (the destination cell displays like this "='DB-B4-B'!BW72:BZ72" only). I am sure that, it caused not because of merging the cells. Do we have any solution???

Thanks in advance....

 

[Hui]

Saajscaria


You can't use a formula as you have done which refers to a Range ='DB-B4-B'!BW72:BZ72


To use as a reference to a single cell

='DB-B4-B'!BW72


or to:


Sum a Range

=Sum('DB-B4-B'!BW72:BZ72)


Max

=Max('DB-B4-B'!BW72:BZ72)


etc

 

[saajscaria]

Hi Mr. Hui,

Thanks for your attention. Actually this link is not for a range of cells. The above mentioned cells (BW72, BX73, BY73 & BZ74) are merged cells. When we put the link from this cell (merged cell) to the destination cell, the cell reference in the destination cell has to be "BW72". I have made a lot of links between these worksheets. Except some cells, everywhere the link is functioning in proper way, ie, "='DB-B4-B'!BW72".

Is there any problem with the cell format??

 

[Hui]

If you enter

='DB-B4-B'!BW72

you will get the value in cell BW72 on sheet DB-B4-B


Make sure you don't have Formula's Displayed Ctrl ~ will toggle that on/off

 

[saajscaria]

Dear Mr. Hui,

Sorry, I am unable to solve this issue... If you don't mind, can I send you the work sheets? Need your help really.......

 

[Hui]

Click on Ninja under my photo

Email is at bottom of page

 

[Hui]

Sajan


Change


Sheet: SMDB-B1-B


BG22: ='DB-B4-B'!BW72

BK22: ='DB-B4-B'!CA72

BO22: ='DB-B4-B'!CE72


When you have merged cells always refer to the upper left cell

eg when you goto the merged cell BG22:BJ22, the cells reference as a merged cell is BG22


I don't know how BG23 ='MCC-B1-B'!$BG$31:$BJ$31 is working?

Technically it shouldn't


you should only use ='MCC-B1-B'!$BG$31


As a note I avoid Merged cells like the plague

They create more trouble than they are worth