Excel doubt

Save Share

This query is : Resolved

Sumitha K (Querist)

06 February 2011 Hello Experts,

I have a small doubt in excel.
Lets suppose there are 3 sheets in workbook.
AA1 in sheet 2 = A1 in sheet 1. Now A1 is linked to AA1.

If I want to know if A1 is linked to any other cells in workbook is there any shortcut to check?

Please reply.

Sumitha

CA PARAS BAFNA

CA PARAS BAFNA (Expert)

06 February 2011 Short Cut to Check :

I haven't found such shortcut, but if you
change the values of A1 as some thing like
ppppp you can see manually the linked cells
in respective sheet.
After finding it out, you may repale the values of the cell A1, with original value by pressing ^Z.

If you receive any short cut , please inform.

Message likes : 1 times

Sumitha K

Sumitha K (Querist)

06 February 2011 Sir,My doubt is for example in financials we link items in balance sheet, p&L and schedules to TB.
If i go to TB directly can i know where each item is linked rather than going to Balance sheet, P&L and schedules to see the link.

Waiting for your reply.

Sumitha

Sumitha K

Sumitha K (Querist)

CA PARAS BAFNA

CA PARAS BAFNA (Expert)

06 February 2011 I am not certain but you may get certain useful information in Excel Tools menu.
You will find Formula Auditing command.
You try them. I think you may get the solution.

Message likes : 1 times

Juzer Sadikot

Juzer Sadikot (Expert)

06 February 2011 Hey Sumitha,

I guess u wanna trace dependent, Try this CTRL + ]

Let me knw if u hav ny other issue.

Regards
Juzer

Sumitha K

Sumitha K (Querist)

06 February 2011 Hello Juzer,
Thanks for your note.
No Actually it does not work.
Example: Cell A1 in sheet 1= Rs.1000
Cell A1 in sheet 2= Cell A1 of sheet 1.
Now if you go to cell A1 in sheet 1 and press Ctrl ] it will not work i.e it will not show you that it is linked to cell A1 of sheet 2.
Please reply.

Regards,

Sumitha

Juzer Sadikot

Juzer Sadikot (Expert)

07 February 2011 Hey Sumitha

Gt u, press f5, you will get dependent's
list, select the reference from the list.

I hope it will work for you.

Regards
Juzer

Message likes : 1 times

Sumitha K

Sumitha K (Querist)

07 February 2011 I tried it and it does not work .
Please suggest what to do?

Thanks and regards,

Sumitha.

CA Navin Jain

CA Navin Jain (Expert)

08 February 2011 Click on Cell A1 in Sheet 1
Press "Ctrl ["
U vl automatically be in Cell A1 in Sheet2
It vl certainly help u
revert if need more on it.....

Sumitha K

Sumitha K (Querist)

08 February 2011 Dear Navin,

It will not work. Ctrl [ will work only on A1 sheet 2 but not sheet 1.

CA Navin Jain

CA Navin Jain (Expert)

08 February 2011 Then....
try 'Trace Dependents' on A1 Sheet1
An Arrow will appear
Now double click on the starting point of Arrow
Go To box will open
There u can see which cells in which sheets are linked to the selected cell

Sumitha K

Sumitha K (Querist)

08 February 2011 Hi Naveen,

I tried doing that it will not work.
I am using excel 2007 and tried F5 and then dependents. But no arrow would appear.
What shall I do?

Please reply.

Sumitha

CA Navin Jain

CA Navin Jain (Expert)

09 February 2011 Dear,
I, myself, am using Windows 2007.
U should rather ensure that u have original Windows 2007 installed.
Otherwise, u should take technical assisstance from some computer expert.

Thanx...
Appreciate...
Keep on posting...

Sumitha K

Sumitha K (Querist)

10 February 2011 Hi Navin,

I am using original windows 2007.
I dont understand how it does not work on my system,
Are there any options to be ticked in excel options?

Regards,
Sumitha

CA Navin Jain

CA Navin Jain (Expert)

11 February 2011 I suggest u to perform the following
steps once again carefully:

1. Go to Cell A1 in Sheet1
2. Click 'Trace Dependents'
3. An Arrow will appear
4. Double Click on the starting point of Arrow
5. 'Go To Box' will open
6. Select the path in 'Go To Box'
7. Click 'Open'
8. U will be taken to the linked cell

Message likes : 1 times

Sumitha K

Sumitha K (Querist)

14 February 2011 Dear Navin,

Thanks. its clarifed.

Regards,

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now