Pivotchart default view

rovinrail

New Member
Joined
Sep 27, 2005
Messages
30
I have a query saved as a pivotchart, and I want to be able to let another user look at it as a pivotchart. However, each time that I re-open the query, it defaults to the datasheet view.

So, is there any way to make a query default to a different view than datasheet when first opened? Thanks!
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
In the form's Properties, go to the All tab and look for Default View.

Change that to PivotTable or PivotChart.

Denis
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,538
Members
410,547
Latest member
htran4
Top