Pivot Tables, pasting and formatting

Rudy Ramos · Mar 11th, 2002, 05:16 AM

Is there a way to "unhook" a pivot table but keep the formatting? I need to send a number of sales report formats based on a pivot table, and using the auto format makes it easy to provide readable reports. The file size is too big, and I don't want to send the data along with the report. And when I copy and paste special, I can only paste the data, losing the formatting. Any ideas?

Thanks

Dave Hawley · Mar 11th, 2002, 05:18 AM

Hi

Once you have pasted as values you should still be able to repaste again as "formats only"

Rudy Ramos · Mar 11th, 2002, 05:23 AM

Duh! I knew I was overlooking something simple. Thanks! Talk about quick responses.

Rudy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 05:16 AM	#1
Rudy Ramos New Member Join Date: Mar 2002 Posts: 2	Is there a way to "unhook" a pivot table but keep the formatting? I need to send a number of sales report formats based on a pivot table, and using the auto format makes it easy to provide readable reports. The file size is too big, and I don't want to send the data along with the report. And when I copy and paste special, I can only paste the data, losing the formatting. Any ideas? Thanks

Mar 11th, 2002, 05:18 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Once you have pasted as values you should still be able to repaste again as "formats only"

Mar 11th, 2002, 05:23 AM	#3
Rudy Ramos New Member Join Date: Mar 2002 Posts: 2	Duh! I knew I was overlooking something simple. Thanks! Talk about quick responses. Rudy