04-01-2011, 06:59 PM
Thanks Basanth.
There was typo in my previous reponse. Correction as below.
If you try to open the Excel Doc externally, you will be able to view my explanation. Hence '=Global!A1' is correct the value is being worksheet "Global" Cell "A1". I believe Excel will not recognize as Column "A" unless you rename the Column naming convention within Excel.
CORRECTION:
If you try to open the Excel Doc externally, you will be able to view my explanation. Hence '=Global!A1' is correct the value is being worksheet "Global" Cell "A1". I believe Excel will not recognize as Column "pUsename" unless you rename the Column naming convention within Excel.
Thanks,
Suba
There was typo in my previous reponse. Correction as below.
If you try to open the Excel Doc externally, you will be able to view my explanation. Hence '=Global!A1' is correct the value is being worksheet "Global" Cell "A1". I believe Excel will not recognize as Column "A" unless you rename the Column naming convention within Excel.
CORRECTION:
If you try to open the Excel Doc externally, you will be able to view my explanation. Hence '=Global!A1' is correct the value is being worksheet "Global" Cell "A1". I believe Excel will not recognize as Column "pUsename" unless you rename the Column naming convention within Excel.
Thanks,
Suba