Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts

    macro to refresh values

    I need a macro that will refresh the values using webservice in Excel 2013. I think ctrl/alt/F9 does it but I need a macro for this. I see an what appears to be an update when I manually enter "ctrl/alt/F9" by the values "rolling" but I do not see this action when I use "Application.CalculateFull" or more ideally "ActiveSheet.Range("A1:B10").Calculate". I cannot tell if these are updating.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi

    ..have you tried Application.CalculateFullRebuild

    zeddy

  3. #3
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    Maybe I don't understand but if a web QUERY simply right click anywhere in the query and select refresh at the bottom.
    Don Guillett
    Excel Developer
    dguillett @gmail.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •