Hi Shiv, If you just want to know the information of linked cells/sheets then, One way could be (CTRL + ` (grave accent)) Go to main sheet tab and press key combination CTRL + ` It will show up the formula used and the sheet names as well.
Note:- If you have some external workbook links then you can go to Edit -> Links. Here you can open one / all of the workbooks linked. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Jun 23, 2009 at 8:13 PM, shivashankar katageri < shankarkatag...@gmail.com> wrote: > DEAR ALL, > > CAN ANY ONE HELP ME OF FINDING OF ALL LINKED CELLS IN MAIN SHEES JUST BY > CLIKING ONE OPEN FLOWER BRACKET, it only opens first linked cell, > > URGENT BASIS, > > THIS WILL SAVE MY TIME > > Please find the attached file > -- > Thanks & Regards > > Shivashankar.C.Katageri. > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
