Cubevalues
Results 1 to 2 of 2

Thread: Cubevalues
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2014
    Posts
    184
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Cubevalues

    Hi Iím looking for VBA code to turn off the screen refreshing on key values in cube functions. I have a large Excel spreadsheet with many tabs and it takes 20 minutes for the system to refresh the information from our SQL Server database. I was thinking if I turn off the screen refreshing of the formulas to only be updated when I select the tab that might speed up the processing of the spreadsheet

  2. #2
    Board Regular
    Join Date
    Nov 2013
    Location
    Denver, Colorado - XFD1048576 - MORE Stuff here near the end. And what if you add even more stuff a
    Posts
    615
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cubevalues

    Hi shophoney - Have you tried:

    Code:
    Application.ScreenUpdating = False
    Happy Excelling ,

    goesr

    To enter code in your post use the format below. Click the link for more detail.
    [CODE] ... Your Code Here ... [/CODE]

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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