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.
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 :
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
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
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
**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
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
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.
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
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
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
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
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.
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
14 matches
Mail list logo