Skip to Content
author's profile photo Former Member
Former Member

Workbook problem

Hi All

Why not all the queries refreshing when I refresh the workbook. I've checked the propoertis all the queries have the smae propoerties.

Regards,

Charan.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Sep 04, 2009 at 10:30 AM

    3.X or 7.0 ?

    Add a comment
    10|10000 characters needed characters exceeded

    • To refresh all queries:

      1) Keep the mouse pointer/Cursor in the sheet which is not "Active sheet" (where there is no query data or components of query) some white part in the excel of same sheet. This is critical part for refresh all queries in workbook to work.

      2) Now hit the refresh button in the toolbar.

  • author's profile photo Former Member
    Former Member
    Posted on Sep 04, 2009 at 03:14 PM

    make sure your mouse pointer is outside the results or free char area, then hit refresh button you will get a message ask you whether refresh all query in the workbook, select "yes" if you want to refresh all queries

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 05, 2009 at 06:25 AM

    Hi,

    In BEx 3.x, After you have opened the workbook, go to the context menu (Right click), you would get the option of Properties, Go to the tab that says interaction, Now check the option that says "Refresh query when opening workbook", and click the button that says OK for all Queries.

    Hope this helps,

    regards,

    Sree.

    Edited by: Sree Nair on Sep 5, 2009 8:26 AM

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.