Forum

Hi Charlie, You are welcome. I am glad I could help you with your issue. Br, Anders

Hello, Please try with adding the full path to the file. =SUMIF('F:BackupBST ExcelRisk[Workbook-A.xlsx]WBA'!D4:D11,5,'F:BackupBST ExcelRisk[Work...

Hi, My recommendation is to use Power Query, but below answer is how to reference using a formula. To reference to a range in another workbook y...

Hi Dorothy, It is always easier to give help if there is a file attached, so we can see the data. You don't have to have the real data in, just som...

Hi Charlie, Please check attached file to see if this is what you want. Br, Anders

Hi Frans, Well, this gave me some lessons learned. I previously thought that you only got a Power Pivot table when you connected two or more tables...

Thanks Frans, Seems the "rules" of how to use GETPIVOTDATA differs between a regular Pivot Table and a Power Pivot Table. I need to read more about...

Hello Elinor, If you want to improve the document you should go with the solution that Mynda suggested, it will among other benefits make it easier...

Hi Terri, This sounds to me like interactive tooltips, partly anyway. I am pretty sure you can build this with VBA, but you can of course build som...

Hello, Go to Data tab and click Queries & Connections, from this view you can remove the queries. Br, Anders

Hi, I would say that if you clean up the data in RECOMMENDATION column in Expired Policies sheet so that you have a fixed number of different recom...

Hi Vivek, This is a topic I am not that familiar with, I simply avoid to reference to other files unless working with Power Query. I found this art...

Hi, As usual with Excel, there is more than one way you can do it to get what you want. The result is the same as what Sunny already gave you, just...

Hi Tarun, Please provide a sample file plus more details of what you are trying to achieve. Br, Anders