$$Excel-Macros$$ Pivot table problem

Hi all I have attached a file containg pivot table with some data. I have two qurries 1. I want to put a foruma next to pivot table and want to copy and paste all formula to all rows but its taking freezing cells by default. If data quatity is high than how could i put the formula in all cells.

$$Excel-Macros$$ Re: How to attach?

I also have the same problem. Whenever I reply to any post, I don't get option to upload a fine in post. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made

When you open a workbook and then close it with out making any changes, you are prompted as follows: Do you want to save the changes to Filename.xls? Microsoft Excel recalculates formulas when opening files last saved by an earlier version of Excel. How to get rid of this problem File is

Re: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made

Hi Rahul, Which version of Excel are you using? Regards Andy On Sat, Aug 7, 2010 at 5:08 PM, rahul axyin.ra...@hotmail.com wrote: When you open a workbook and then close it with out making any changes, you are prompted as follows: Do you want to save the changes to Filename.xls? Microsoft

Re: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made

By default, Microsoft Office Excel 2003 and Microsoft Excel 2002 recalculate files that were last saved in an earlier version of Excel. This ensures that any improvements made to the Excel calculation engine are applied to all formulas in the workbook. To prevent Excel 2003 or Excel 2002 from

$$Excel-Macros$$ Help for Pick data from access to Excel

**Dear All, I need your help I have some Mobile nos in 'a' colmn ..and that mobile no related other information is availble in MS-Access table (data volume is 6lac) Mobile No Name Add1 Add2 Add3 Alternate no 123456 325641 267789 325641 Please suggest me any macro

Re: $$Excel-Macros$$ Need max date

I'm getting the result #VALUE!.  Could that be because what in column A in both sheets is alpha numeric? From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Fri, August 6, 2010 6:53:33 PM

Re: $$Excel-Macros$$ Need max date

I should have clarified that in the sample it is only numeric and it works but in my actual data it's alpha numeric.  It didn't occur to me it would make a difference when I created the sample.  Can I trouble you to take another look at it with alhpa numeric data in Col A?  Sorry about that.

RE: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made

Hi I am using excel 2007 Regards Rahul Date: Sat, 7 Aug 2010 17:52:16 +0530 Subject: Re: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made From: aind...@gmail.com To: excel-macros@googlegroups.com Hi Rahul, Which version

RE: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made

Hi I have already tried the below steps but every time i reopen excel 2007 the option in step no. 2 automatically gets resetted Regards Rahul Date: Sat, 7 Aug 2010 17:55:17 +0530 Subject: Re: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes

RE: $$Excel-Macros$$ Need max date

Hi Nadine, It should still work with alphanumeric data. Any chance of a sample workbook with the formulas in there? Regards - Dave. Date: Sat, 7 Aug 2010 08:26:36 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ Need max date To: excel-macros@googlegroups.com I should

Fwd: $$Excel-Macros$$ Question asked in Interview...

Hello Friends, Waiting for reply Regards, Vijay -- Forwarded message -- From: Vijay Kr. Aggarwal vjaggarwal2...@gmail.com Date: Fri, Aug 6, 2010 at 10:18 AM Subject: $$Excel-Macros$$ Question asked in Interview... To: excel-macros@googlegroups.com Hi, Please check

$$Excel-Macros$$ trying to hire someone very very proficient in excel

i need help on a project to convert complex spreadsheets into a more efficient model. pls advise if anybody available ASAP. We could discuss the payment offline. Thanks -- -- Some important links for excel users: 1.

$$Excel-Macros$$ Need to remove Alt + Enter

I often receive a file that has extra Alt+Enter in it which makes the cells long and therefore the files long.  Is there anyway I can remove these?  The # rows is 700+ - it can vary. Thanks. -- -- Some