[mso] Re: Excel Refresh

That's the thing Jim, the worksheet is packed with links.  The links are
via the New Database Query option under Data/External Data. If you put
your cursor on one the name box says Query_from_...

-----Original Message-----
From: Jim Pettit [mailto:jimpettit@xxxxxxxxx]=20
Sent: Tuesday, April 19, 2005 11:19 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel Refresh

Glenda--

If the 'Link...' menu selection in Excel is greyed out, that means that
there *are* no links for that workbook. You'll need to first create a
link to an external data source (Access, a text file, anoher workbook,
etc.) before that 'Links...' option will be available. After you do
that, we can work on programatically refreshing those links...

--Jim

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Glenda Wells
Sent: Tuesday, April 19, 2005 8:08 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel Refresh

I'll try it Jim.  I haven't had any luck with VBA so far but maybe this
is THE ONE.  What I don't understand about what I've already got is why
my links option on the edit menu is greyed out.  Everything I researched
on Microsoft's web site indicates it should be available and the the
answer to my problem. Technology...go figure!=3D20

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Glenda Wells
Sent: Tuesday, April 19, 2005 7:25 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel Refresh

I have an Excel worksheet wherein all the cells are linked to data in an
Access database.  When I open the worksheet, a message to enable
automatic refresh pops up. I want it to refresh without me having to
click the button.
My Links option on the Edit menu is greyed out and I can't figure out
why.
This is all XP/2003.=3D20

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: