Posts by Carim

Glad to hear you have managed to fix your problem

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

Billyrj

Do you consider this thread as Resolved ? or do you still need some assistance ?

alansidman

Thanks a lot for the Power Query links !!!

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 Functions

Dynamic 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.net

Hope 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

and if your Julian date : 23V043 is located in cell B6 .... should you need to convert it back to 12/02/2023 :

 =DATE(IF(0+(LEFT(B6,2))<30,2000,1900)+LEFT(B6,2),1,RIGHT(B6,3))

.... and also ... do we agree the formula for conversion is :

=RIGHT(YEAR(B3),2)&"V"&TEXT(B3-DATE(YEAR(B3),1,0),"000")

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

Hi again,

If your workbook does not have any macros ... you could test following to be be inserted in the module ThisWorkbook

Sub Workbook_Open()
   Application.DisplayAlerts = False
   Application.AskToUpdateLinks = False
   Application.DisplayAlerts = True
End Sub

Hope this will help