Pivot tables Issues

dessim

New Member
Joined
Aug 4, 2019
Messages
23
Office Version
  1. 2016
Platform
  1. Windows
Evening Ppl,

I have some issue with Pivot Tables.

Dont mind bear with me & advise some solutions if possible.Greatly appreciated.

https://drive.google.com/open?id=1qtKw3ZJWd8ImthY4GWhPdr6uofQa1fbl

I have attached a workbook - Demo Ques.

Basically I am facing some issue when i click on the data value on the pivot table sheet.

Ques 1: when click North City Data Value -> Sheet 1 will appeared as seen. All the data will be "squeezed" with the columns.

1) Is there any method to autofit the content within each individual cells (to show the hidden content)
rather than to manually have to use "wrap text function" over the cell ?

2) Is there any setting we could do to align all the datas within the cells

Ques 2: When I click on North City Data Value more than 1 times, sheet 1, Sheet8, Sheet 9 will appeared accordingly. Number of sheets appearing will be based on the number of times I clicked.

1) Is there any way this sheet appearing feature in pivot tabel can be "control" or manually deleting the new sheets is the only solution ?

Seek some kind assistance one the above.


Thank you.

Regards
Des
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Drilling to detail creates a new sheet and does nothing more with formating

There are a number of routines around that that can delete sheets name sheet when you close or change focus

other than that I think you are seeing bog standard events

make sure your main sheet is not called sheets-something
 
Upvote 0
Drilling to detail creates a new sheet and does nothing more with formating

There are a number of routines around that that can delete sheets name sheet when you close or change focus

other than that I think you are seeing bog standard events

make sure your main sheet is not called sheets-something

Seek your kind enlightenment.
Pardon my poor understanding on the issue, I dont really get what u mean.
 
Upvote 0
the code is like

Code:
Sub macro2()

Dim i As Long

Application.DisplayAlerts = False

For i = 1 to Worksheets.Count

If Worksheets(i).Name Like "Sheets*" Then Worksheets(i).Delete

Next i

Application.DisplayAlerts = True

End Sub</pre></pre>

depends how you want to use it to auto delete on workbookclose maybe
 
Upvote 0

Forum statistics

Threads
1,213,562
Messages
6,114,322
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top