viewing the code of a spreadsheet

[chris]

Howdy all. I'm a Excell newbie so please bear with me. If
someone sends me a spreadsheet, is there a way for me to
look @ the SQL code that was written to produce those
results?

 

[Guest]

Hi,

the way I know is to right click on the cell,
and select "edit query". There may be other
ways depending on how the data is brought in
(I'm not that familiar with them.)

 

[LAURA2018]

Sure, a couple different ways. Right click on the tab of the spreadsheet and
view code. Or to view the macro go to Tools, Macro, Macro..., pick the macro
you want then edit.

 

[chris]

thx

-----Original Message-----
Hi,

the way I know is to right click on the cell,
and select "edit query". There may be other
ways depending on how the data is brought in
(I'm not that familiar with them.)


.