external data

[00Eric Clapton]

I am using external data in a spreadsheet using ver 97 and found that the
refresh data button suddenly gray out. Can anyone please help me why it is
like that? Thanks.

 

[Nick Hodge]

Is the sheet protected?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]

 

[00Eric Clapton]

How can I tell?

Is the sheet protected?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]

 

[00Eric Clapton]

Can anyone please help? Thanks.

How can I tell?

 

[Dave Peterson]

look under:
tools|protection|
If you see unprotect sheet, it's protected.