Miss old auto format from Excel 97


Posted by Dave D on October 08, 2001 8:28 AM

I just upgraded from Excel 97 to Office 2000. We use pivot tables constantly and our group prefers the look of autoformat LIST 2. It gives you the classic alternating green and white rows. How can I get this on a new pivot table. I can see it when I open an old pivot table, but I cant figure out how to import it? Help!



Posted by Dave D on October 08, 2001 9:52 AM

Let me rephrase this. List 2 is available if I want to autoformat a series of numbers in Excel 2000, but not when I try to autoformat a pivot table. Why is this happening?