Forum Discussion
Need help to resolve Excel Formula using Let,Take,index,Sort,Unique,HSTACK,MMULT,TOROW,MONTH.
Thank you. Do I understand correctly that csv62719 is you source file. If to avoid Power Query we copy/paste data from it into the sheet in main file, here by formula create massaged range and based on it and month/year/monthid parameters create aggregated result. Workflow is correct?
Once again thank you for your kind help. It has been a long three weeks since I started this project.
Norman_McIlwaine , thank you for the feedback.
Above is just formula which you may edit directly in formula bar. If you check the file from previous post it's here
but practically not visible if you don't expand formula bar. For that click on any empty place within it and Ctrl+Shift+U. Or drag bottom border down.
Editing here use Alt+Enter to insert new line.
In addition you may install Excel Labs add-in from the Store
within it it'll be Advanced Formula Environment to work with formulae and not only.
- I did the repair and installed the latest Microsoft 365 from online and continue to get the same errors when inserting a PIVOT Table.
So far, I have narrowed down the MSOLAP$LocalCube error to when I select a Table in Excel and use the Insert -Pivot Table command four errors appear immediately in the Event Viewer Log. However, if I continue and create a pivot table then delete the pivot table and I recreate using same commands against the same Excel Table Insert Pivot Table I do not get an error message. If I change my Excel Table to another Table and perform insert Pivot command the error appears.
Is this a bug with EXCEL or PIVOT Table?
Your expertise would be appreciated. Tried to add data to data and I get the MSOLAP error message. I will now do a repair of Microsoft 365 and see if that will clear the error message.
That's quite old thread Event ID 25 from source MSOLAP$LocalCube (microsoft.com) if something could help from it.
I'd check first if Power Pivot (data model) works on any new file - create simple source table, build PivotTable adding data to data model. If doesn't work perhaps you need to repair the Office.
Is that on Windows?
Ok. Thanks for the speedy response. I have been updating my skills and using Power query with Pivot Tables. I am not sure if this is an excel question or a Microsoft question. Every time I open a pivot table for an Excel table, I get four error messages in my event log:
I have tried installing the MSOLAO like it says and still get the same error message. Have you seen a fix for this anywhere?
I'm not familiar with iPad. If Power Query that's only to refresh. Otherwise to build dynamic array formula from scratch.
I have a small problem with not having the capabilities to refresh the data on a IPAD, it is imposable to change the month and get accurate results in the Excel output. I have tried to work around this and still run into the same problem, I have also requested this as an enhancement to Excel. However, it is not high on their priority list, and I can't get enough votes to get the fix to move it up on the list.
Is there any other way to get the results without having to do a refresh every time.?
HI
I have a small problem with not having the capabilities to refresh the data on a IPAD, it is imposable to change the month and get accurate results in the Excel output. I have tried to work around this and still run into the same problem, I have also requested this as an enhancement to Excel. However, it is not high on their priority list, and I can't get enough votes to get the fix to move it up on the list.
Is there any other way to get the results without having to do a refresh every time.?
- Thank you for the quick and excellent response.
