Glad to hear you have managed to fix your problem
Posts by Carim
-
-
Hello,
Without a sample file, it is quite difficult to guess all your constraints and how the Pivot Table operates based on which data ...
As a general answer, for a simple and easy workaround, you can add a Column to your database which provides the foundation for your Pivot Table ...
Hope this will help
-
Hello,
You can use Filter to see your results ... see attached
-
Hi,
Have you tested the custom format : [>=10000000]" "##,##,##,##0;[<0]" "\ ##,##,##0;" "##'##0
Hope this will help
-
-
-
Glad to hear this is helping you out
Once you have decided to Insert a Pivot Table ... you just need to drag the fields you need either in rows, in columns or in the values area ....
-
Hi again,
You do need to very carefully examine (and adjust) each and every setting of your Trust Center ...
since Microsoft Office is after over-protecting you ... even beyond your own will ... !!!
Forgot to mention the pop-up you are getting has nothing to do with Links ... and Updating Links ...
-
Hi,
Dave BURNS from Exceljet has done an excellent work to solve hard problems in Excel older versions - WITHOUT the 6 Main Dynamic Array Functions !!!
Alternatives to Dynamic Array FunctionsDynamic Excel offers 6 brand new functions that solve hard problems in Excel like sorting, filtering, and working with unique values. For those not using…exceljet.netHope this will help
-
Hi,
The message you are getting is related to Excel> Options>Trust Center > Trust Center Settings > Trusted Locations > Add New Location
where you can add your own G:\Art Stuff\ folder
Hope this will help
-
Hi,
What about an ultra-basic Pivot Table ... less than 5 seconds ...
-
Once you have tested all the formulas and the UserForm, feel free to share your comments
-
Where to Store Macros
In your case, for the module ThisWorkbook, it is The Second Choice ...
-
Have you tested the suggested solution ...???
-
Attached is your Test file with the UserForm VBA formula ...
Hope this will help
-
-
-
Hi and Welcome to the Forum
Before going into the UserForm ...
Do we agree that 23V043 is 12/02/2023 ... February ... and Not January ...
-
The one thing you can test is to Open your File and copy the macro posted in message #5 in the module named ThisWorkbook
Once your file is opened, press simultaneously the keys Alt F11 and double-click on the left-side on the module ThisWorkbook
In the window on the right, you can copy the suggested macro.
Then Save your file and close Excel.
Next time, opening your file will trigger automatically your macro ... and you should not get the pop-up message
Hope this will help
-