refreshing external data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jason.yanes@fiu.edu - 27 Apr 2007 21:34 GMT

i am having trouble refreshing my data onto my excel worsheet. the
data option is grayed out. I'm able to do this on a pc but not on my
MAC. can anyonw help me out. thanks

Reply to this Message

CyberTaz - 28 Apr 2007 00:17 GMT

What version of Excel? What kind of data are you trying to _refresh_? What
"data option" is dimmed out? Is this a file you created on your Mac or did
it come from another source? If another source, what?

There's no doubt someone will be willing & able to help you, but you've got
to help us see what the problem seems to be - we aren't able to look over
your shoulder :)

Regards |:>)
Bob Jones
[MVP] Office:Mac

On 4/27/07 4:34 PM, in article
1177706053.098303.206740@t39g2000prd.googlegroups.com, "jason.yanes@fiu.edu"

> i am having trouble refreshing my data onto my excel worsheet. the
> data option is grayed out. I'm able to do this on a pc but not on my
> MAC. can anyonw help me out. thanks

Reply to this Message

jason.yanes@fiu.edu - 28 Apr 2007 16:30 GMT

> What version of Excel? What kind of data are you trying to _refresh_? What
> "data option" is dimmed out? Is this a file you created on your Mac or did
[quoted text clipped - 15 lines]
> > data option is grayed out. I'm able to do this on a pc but not on my
> > MAC. can anyonw help me out. thanks

I am runing version 11.3.3 , I'm trying to refresh raw data that comes
from the internet. the refresh data button is grayed out. File was
created on a PC

Reply to this Message

jason.yanes@fiu.edu - 28 Apr 2007 16:33 GMT

I am runing version 11.3.3 , I'm trying to refresh raw data that comes
from the internet. the refresh data button is grayed out. File was
created on a PC

Reply to this Message

CyberTaz - 28 Apr 2007 18:42 GMT

Okay, I'm not an expert on this, but I think I know what the problem is.

Web Queries are saved as separate files, so if the query wasn't brought
over/recreated on the Mac along with the .xls your file can't make the
necessary connection - IOW, the link is broken & therefore can't be
refreshed. The current copy of the file essentially now stores static data.

I'm certain someone will give you more specific ideas on how to proceed, but
in the meanwhile you may want to review XL Help on Web Queries - they're
handled differently in Mac XL than in the PC version.

Also - no real bearing on this issue perhaps - but I'd suggest you update
Office. Current version is 11.3.4

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 4/28/07 11:33 AM, in article
1177774418.023878.5730@y5g2000hsa.googlegroups.com, "jason.yanes@fiu.edu"

>> What version of Excel? What kind of data are you trying to _refresh_? What
>> "data option" is dimmed out? Is this a file you created on your Mac or did
[quoted text clipped - 19 lines]
> from the internet. the refresh data button is grayed out. File was
> created on a PC

Reply to this Message

Mac Forum / Applications / Excel / April 2007

refreshing external data