Forum

Because the pivot tables have the same source of data, a slicer can control both pivot tables, just add a Site slicer in Report sheet, right click the...

Use Now() + TimeSerial(0,0,30) to add 30 seconds to the current time. For a different sheet query, use: ThisWorkbook.Worksheets("AnotherSheetNam...

Hi Michael, Try this query: let Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], Custom1 = List.Accumulate(List.Split(Table.Colum...

I think the matter is too complex to handle it with excel simple formulas.

Hi Tanya, When the code breaks, press Debug then type into Immediate window: ?Rng.Address - then press Enter and provide the result and: ...

Hi Saliha, Is it the FIFO method you are trying to implement? See the solution here: Or:

Hi Jörg, Power Query is for data transformations, Power Pivot is for data analysis. The data model is associated to the workbook, not to power q...

Where is that string located? Id is in column A, if the string is in column D for example, you can add a new column where you combine columns A and D,...

Only if you open them you will know.

Ok, those macros that are called needs to be called only from the form? They can be called from ribbon, not seeing any reason to use them only in f...

Worths to try: Application.Wait Now()+TimeSerial(0,0,20) for a 20 seconds delay. Hard to debug if the error is not consistent though.

Here are the instructions: If the file is updated by a different user, the permissions are dropped, the new user will be asked to set the permiss...

Hi Matt, What kind of queries, are those power Queries? Try setting the privacy to None for those workbook query permissions, if they are PQ que...

Is there a reason for using this menu in a userform? You have much better options, you can build a custom menu in ribbon, even in runtime if a dyna...

Hi Ivaylo, The form does not load on my side, this line errors out: g_lpMyWndProc = SetWindowLong(g_hForm, GWL_WNDPROC, AddressOf HookWinProc) (...