Post reply

Wishful thinking

  • August 16, 2006 at 3:05 pm

    #113269

    is there a program or a way to make an xls refresh off a cube automatically. for instance make a xls re-query once a week?

  • August 17, 2006 at 4:04 am

    #655401

    If you are filling your .XLS with the help of Import External Data, you can configure your 'External Data Range Properties' to refresh every X minutes, everytime the .XLS is opened or similar stuff.

  • August 18, 2006 at 7:23 am

    #655630

    Another way will be to write a vb script that either asks the user if he/she wants to refresh the data, or just check for the day of the week and force the refresh.

    Then save this script as the autostart macro, and you got it.

  • August 21, 2006 at 2:45 pm

    #655989

    ok but that is still to manual. That takes someone opening it. I want it so it sends out refreshed using the SQL server only.

  • August 22, 2006 at 4:40 am

    #656085

    That sounds like a job for SQL Server Reporting Service!

     

    And yes, you can do exactly that.

    Happy (ab)use of it!

    Hanslindgren

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply