Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Tolli1

  1. Tolli1

    Worksheet PRotection & Pivot Tables

    I have a spreadsheet with a pivot table that "Refreshes on Open" as the data source is regularly updated. On the same spreadsheet there are cells which are updated manually by users, however, I want to protect some of those cells. Unfortunately it appears that Pivot Tables will not...
  2. Tolli1

    Show Multiple Parameters

    If you want to provide details of the parameters used in a report you stick the parameter field somewhere i.e in the report header, however, what about if there are multiple values? Currently if I put the (multiple value) parameter field in the report header it only provides the very first...
  3. Tolli1

    Location of SQL Query

    I have a number of reports which attach to SQL queries, however in v8.5 I can't establish the query location. I'm sure in v7 I used to click on set database location and the file path for the query would be provided. Is there an equivalent in v8.5. Thanks Tolli1
  4. Tolli1

    Pivot Table - Percentage of a Sub Total

    Is it possible to add a column to a pivot table which will show the values that make up a sub total as a percentage of the subtotal? Thanks in advance!! Tolli
See more

Part and Inventory Search

Back
Top