Formatting of data detail on a new sheet from a Pivot Table

P

Popeye

Hi everyone

I have Excel 2003 and have successfully created a Pivot Table which presents
data as I need. However, when I double click one of the entries to give
details of the entries which contribute to the data, the new sheet that's
created doesn't retain the formatting of the original raw data. One of the
columns of data (in the raw data) is formatted as [m]:ss.00 but the data is
presented on the new sheet formatted as hh:mm:ss. If I am to share the pivot
table and data with others, I'd like to be able to retain the original
formatting. Is this possible? I know that I could reformat the new sheet as
I want, but some users of the information may not be able to do that and will
be confused by the format of the time column. I'd also like to be able to
retain some of the other formatting from the raw data (such as cell
background colour, bold etc.).

Thanks for your time.
 
D

Debra Dalgleish

There's no built in way to format the drill to details sheet that's
created. You can format the sheet manually or programmatically, after
it's been created.
Hi everyone

I have Excel 2003 and have successfully created a Pivot Table which presents
data as I need. However, when I double click one of the entries to give
details of the entries which contribute to the data, the new sheet that's
created doesn't retain the formatting of the original raw data. One of the
columns of data (in the raw data) is formatted as [m]:ss.00 but the data is
presented on the new sheet formatted as hh:mm:ss. If I am to share the pivot
table and data with others, I'd like to be able to retain the original
formatting. Is this possible? I know that I could reformat the new sheet as
I want, but some users of the information may not be able to do that and will
be confused by the format of the time column. I'd also like to be able to
retain some of the other formatting from the raw data (such as cell
background colour, bold etc.).

Thanks for your time.
Click to expand...
 
P

Popeye

Thank you Debra - I suspected that may be the answer.

I'll look into producing the format automatically via VBA when the new
worksheet is created. Many of the end-users won't be able to format the
sheet correctly and all they will want to do is double click an item to have
Excel retrieve the details for them.
 
Top