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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot table and a thin book 1

Status
Not open for further replies.
vladk

vladk

Programmer
May 1, 2001
991
US
Hi,

Is it possible to create a workbook with a pivot table, which is connected to a large, say ACCESS, table (may be 400MB), and still have a very light book? And if its possible, how it can be implemented?

Thank you

vladk
 
Sort by date Sort by votes
Yes, it's possible. In pivot table properties untick 'save data' option.
With code (PivotTableObject is a reference to the pivot table):
PivotTableObject.SaveData = False

combo
 
Upvote 0 Downvote
combo,

Thank you so much! This is exactly I was looking for!

vladk
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
591
mintjulep
M
arvarr
  • Locked
  • Question
Variable in Pivot Table 1
Replies
4
Views
229
arvarr
arvarr
Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
833
remeng
remeng
arvarr
  • Locked
  • Question
Pivot Table drill through in a new workbook
Replies
3
Views
304
arvarr
arvarr
remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
406
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top