[mso] Re: Excel Refresh

 
Hi Glenda, 

  

Regarding to the  message to enable automatic refresh, to avoid it, why
don'tyou try the following in the Excel menu: 

  

Tools 

    Macro

          Security 

                  Level Security 

                   Put the security level in Low 

  

Hope it helps. 

  

Best regards 

Alex >From: "Glenda Wells" <gwells@xxxxxxxxxxx> >Reply-To: mso@xxxxxxxxxxxxx
>To: <mso@xxxxxxxxxxxxx> >Subject: [mso] Re: Excel Refresh >Date: Tue, 19
Apr2005 11:41:06 -0400 >>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
>answerto 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
usethe 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
>************************************************************* 

----------------------------------------------------------------------------
Platica con tus amigos en línea con T1msn Messenger: Haz clic aquí [1]

--- Links ---
   1 http://g.msn.com/8HMAESMX/2734??PS=47575
*************************************************************
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: