Dear Sumeet,
You have to remove the tick from *auto format table* which is in the *Pivot
table - table option - Format options - auto format table.*
I hope this is useful to you.
Thanks & Regards,
Lavprasad Kori
MIS Executive - Water
Tel. 022 - 39833428
On Fri, Feb 27, 2009 at 2:49 AM, Sumee
thank you all of you guys ;) you're great ;)
On Feb 26, 4:33 am, "saravanan" wrote:
> Hi,
>
> You can also use the below code
>
> Sub del()
>
> ro = 1 'Starting Row
>
> Col = "A" 'Column in which the extra word contains
>
> While Range(Col & ro).Value <> ""
>
> If Range(Col & ro).Value = "Extra"
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
--~--~-~--~~~---~--~~
1. Open your excel file which you are using.
2. Press ALT+F11
3. Open This Workbook, which you can find under Project explorer->your
excel sheet.
4. Paste the below code.
Private Sub Workbook_Open()
Application.Calculation = xlCalculationAutomatic
End Sub
Let me know if t
Hello Freinds!!
I am novice in Excel and want to inquire that can we link Excel to
some site so that Data can be downloaded automatically every time we
open that particular Excel file.
Lets take problem,
Suppose i need to download Exchange rate Daily from RBI site in some
format can i do it.
-
Hi Rajesh,
If memory serves, if you open a workbook that is set to 'automatic
calculation', then open another workbook that is set to 'manual
calculation' in the same session of Excel, then both workbooks will be
set to manual calculation.
I say 'if memory serves' as this doesn't seem to occur i
If the spreadsheet is large, recalculation isn't something that happens quickly!
During Recalculation, if the user clicks inside of a cell, or hits the "escape"
key, or a variety of other things, then recalculation is suspended, the word
"Calculate" appears in the status bar, and Excel switches
Hi Rajesh,
For the Calcuation Setting you have to go to *Tools - Options - Calculation*
**
In calculation pane there is options of :
*Automatic*
*Automatic except table*
*Manual*
**
I hope this is useful to You.
Regards,
Lavprasad Kori
MIS Executive
Hindustan Unilever Limited
Mob : 9867931351
