Excel Pivot Table Question - Chicagoland Sportbikes
Chicagoland Sportbikes
 
Geek Squad to the rescue! fucken computer crashing on you again? another porn site infected your computer? tierd of your wife seeing your anal fisting videos and want to lock her out of the external HD? get the answers you need from our local computer experts.

 
LinkBack Thread Tools Display Modes
post #1 of 2 (permalink) Old 09-01-2010, 11:10 AM Thread Starter
Registered User
 
Gone In 3's Avatar
 
Join Date: Mar 2009
Location: Texas/Chicago
Posts: 5,771
Location: Texas/Chicago
Sportbike: CBR1000RR
Years Riding: Been around the block with training wheels
How you found us: Folks
           
Excel Pivot Table Question

I have pivot tables in a particular layout which need to be populated every month with new data. To be specific, certain items in the tables are left unchecked.

When I populate the new data and hit refresh, all the items automatically become checked, thus changing the original layout.

How can I enter new data and retain the format by keeping certain items unchecked? I've tried a variety of different methods with no avail.

Example:

Before refresh:


After refresh:


I'm using Excel 2007.
Thanks
Gone In 3 is offline  
Sponsored Links
Advertisement
 
post #2 of 2 (permalink) Old 09-02-2010, 09:36 AM Thread Starter
Registered User
 
Gone In 3's Avatar
 
Join Date: Mar 2009
Location: Texas/Chicago
Posts: 5,771
Location: Texas/Chicago
Sportbike: CBR1000RR
Years Riding: Been around the block with training wheels
How you found us: Folks
           
Bump
I know we got some real Excel gurus over here.
Gone In 3 is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the Chicagoland Sportbikes forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome