Skip to main content

Conas formáidiú a chaomhnú tar éis tábla pivot a athnuachan?

Uaireanta, féadfaidh tú marc seiceála an Formáidiú cille a chaomhnú ar nuashonrú mír sa tábla pivot roghanna trí thimpiste. Agus sa chás seo, bainfear an fhormáidiú tar éis athnuachana má tá formáidiú cille i do thábla pivot. Tá sé seo an-chráite nach féidir leis an tábla pivot an fhormáidiú a choinneáil. Labhróidh mé inniu faoi chleas éasca déileáil leis an tasc seo.

Formáidiú a chaomhnú tar éis tábla pivot a athnuachan

mboilgeog cheart gorm saighead Formáidiú a chaomhnú tar éis tábla pivot a athnuachan

Chun formáidiú na gcealla a choinneáil nuair a dhéanann tú do thábla pivot a athnuachan, déan na céimeanna seo a leanas le do thoil:

1. Roghnaigh aon chill i do thábla pivot, agus cliceáil ar dheis.

2. Ansin roghnaigh Roghanna PivotTable ón roghchlár comhthéacs, féach an scáileán:

doc-keep-formatting-pivottable-1

3. Sa an Roghanna PivotTable dialóg, cliceáil Leagan Amach & Formáid tab, agus ansin seiceáil Formáidiú cille a chaomhnú ar nuashonrú mír faoin déanta alt, féach an pictiúr:

doc-keep-formatting-pivottable-1

4. Agus ansin cliceáil OK chun an dialóg seo a dhúnadh, agus anois, nuair a fhormáidíonn tú do thábla pivot agus é a athnuachan, ní bheidh an fhormáidiú imithe níos mó.

Earraí gaolmhara:

Conas leithead an cholúin a ghlasáil sa tábla pivot?

Conas an tábla pivot a athnuachan ar chomhad atá oscailte in Excel?

Conas an tábla pivot a athnuachan nuair a athraíonn sonraí in Excel?

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup  |   VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle   |  Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla   |  Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí:  12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
Comments (21)
No ratings yet. Be the first to rate!
JORDI RIUS
JORDI RIUS
This comment was minimized by the moderator on the site
Achei, pelo menos aqui deu certo. Óbvio que a opção "Preservar a formatação da célula ao atualizar" deve estar marcada. A partir daí, deve-se aplicar a formatação com a opção da Aba: Análise de Tabela Dinâmica/Grupo: Ações/Opção:Selecionar/Habilitar Seleção. Aquilo que for selecionado com a função "Habilitar Seleção" manterá o formato. O chato é que às vezes seleciona toda uma coluna e às vezes seleciona só uma cela. Aí tem que fazer cela a cela, mas deu certo aqui.
Reply
0
0
andy
andy
This comment was minimized by the moderator on the site
Actually, you need to format each field data type, and make sure the whole pivot table settings are set to retain the formatting when refreshed. 
Reply
0
0
stefan
stefan
This comment was minimized by the moderator on the site
You can use the VB script:"Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)"
and put all formating information in between. This routine will be carried out after changing Pivottable content
For example:" With Selection
.HorizontalAlignment = xlLeft
.WrapText = True
.Orientation = 0
.AddIndent = False
.IndentLevel = 1
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
With Selection.Font
.Name = "Verdana"
.Size = 8
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
.TintAndShade = 0
.ThemeFont = xlThemeFontNone
End With
End Sub
"You can use the macro recording to find out the formating syntax!
Reply
0
0
Aaron
Aaron
This comment was minimized by the moderator on the site
Check to make sure all the cells in the data are formatted as a date and not a number.
Reply
0
0
Dennis
Dennis
This comment was minimized by the moderator on the site
I fixed mine by on Format Cells Go to Protection and Uncheck Locked!!!!
Presto!!!
Reply
0
0
Dan
Dan
This comment was minimized by the moderator on the site
I've had the same frustration as many of you where the formatting does not remain even though you select the "Preserve cell formatting on update" checkbox. I've found 2 things that helped me out.
- highlight more of the table and format that broader region to define the formatting for the cells that aren't maintaining the formatting you desire. Then, after refreshing, go back and change specific cells to tweak the formatting.
- Darlene's idea of conditional formatting is brilliant and works well. The only thing you'll be missing is alignment and text-wrapping.
- After doing all of this, save and close out of your file. After a moment, re-open your file and try again. I've found that, for some reason, closing the file and re-opening will allow the system to imprint these changes.

Hope this helps.
Reply
0
0
leandro marzliak
leandro marzliak
This comment was minimized by the moderator on the site
It works as soon as you untick, do all your formating and tick again.
Reply
0
0
Jean Rothen
Jean Rothen
This comment was minimized by the moderator on the site
It does work for me when I uncheck the "Autofit column widths on update".
Reply
0
0
Eita porra
Eita porra
This comment was minimized by the moderator on the site
mentira da porra isso.. nunca funcionou corretamente isso
Reply
0
0
Guest
Guest
This comment was minimized by the moderator on the site
This does not work when I try to preserve cell text alignment. For example, I want the text to be left aligned in a particular column. Upon refresh, the format resets.
Note for anyone offering to debug (if any kind soul is brave enough) - I often have multiple fields in the column section.
Reply
0
0
There are no comments posted here yet
Load More
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations