Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: progress bar for a refresh on open pivot tables

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I have a program that uses pivot tables, these tables refresh their contents on open of the workbook,

    my question is how can you provide a dialog or such like that will display the progress of the refresh. Bearing in mind that there are about six pivot tables in the workbook??

    Cheers Ed

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Look up help on Progress bar
    You will need a way to figure out how to break down the process into a mathematical figure or as a second choice, you can use an average time though this would vary on different systems.

    I would insert the progress bar on a userform, but it appears that you can insert one directly on the worksheet itself if you'd like. If you understand pivot tables, you won't have any problem using a progress bar.
    Tom


  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ts, cheers for that... how would I find the progress bar control and how should I attach that to the refresh on open??

    Ed

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi again.
    While in design mode, click on the little tools icon at the bottom of the Control Toolbox menu bar,
    then select the Microsoft Progress Bar.
    I'm assuming that you have it on your system.
    If you need more detail, please repost.
    Tom

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    TS I hate to say it but because I am using a corperate version of MS2000 i don't have that feature... arrgghhhhh Y cannt they just stop being so paranoid

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just as a forethought, how would you suggest that I control the userform, ie make it open without pausing the refresh and make it close once the refresh is complete??

    Ed

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well,
    Some of the guys on here, namely Dave, have raised some security issues with using non-modal forms. If you are using code to work with your pivot tables, you can place this code in the userform itself or you can display the form non-modal or use doevents.
    If you are running Office 2000 then you can use non-modal userforms, if 97, it gets more complicated, but there is a workaround available though I do not have the website link.
    Are you using code to refresh your pivot tables?
    Reply

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Which feature don't you have?

  9. #9
    Board Regular
    Join Date
    Mar 2002
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ts,

    I am using the refresh on open for the pivot tables, should I code the refresh events ??

    I am using COE3.2 version of MS2000...?

  10. #10
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I don't know the first thing about pivot tables.
    I'm new to Excel and it appears there is very little that you cannot code.
    I'm gonna get one of the other guys to help you. You'll get better help.
    Tom

Some videos you may like

User Tag List

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
  •