$$Excel-Macros$$ How to keep Pivots format consistent

Hi All I need to keep the formats (like Column/Rows Width etc) of a Pivot table constant so that every next time when I referesh it, it doesn't loose my formatting and don't get to original formatting. Any advise how to do it? Thanks Sumeet --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: how to activate double click

Try going to Tools - Options - Edit. On left hand side under Settings, you would see the option "Edit directly in cell". Enable it by putting a tick mark and say ok. Now, you should be able to double click directly into the cell. Let me know if I have missed any part of your questions. Rgds Sumee

$$Excel-Macros$$ Re: Can I get Day from date in excel.

Put in Cell A1 10/14/2008 (ie 14th Oct 08) and put in Cell A2 =TEXT(A1,"")... you should get "Tuesday" which is the actual day for this date 14th Oct. ~ Njoi ~ On Tue, Oct 14, 2008 at 12:51 AM, Mayank Patel <[EMAIL PROTECTED]> wrote: > Hi friends, > Is there any worksheet function to get th