Comments for Chandoo.org – Learn Excel, Power BI & Charting Online https://chandoo.org/wp/ Fresh Excel Tips, Power BI, Power Pivot, Power Query, Tricks, Charts, Tutorials, Downloads, Dashboards and Visualization Showcase for your Inspiration and Productivity Sun, 23 Aug 2026 17:40:54 +0000 hourly 1 https://wordpress.org/?v=7.1.4 Comment on Mutual Fund Portfolio Tracker using MS Excel by Abhishek Mishra https://chandoo.org/wp/mutual-fund-portfolio-tracker-using-ms-excel/#comment-2786115 Sun, 23 Aug 2026 17:40:54 +0000 http://chandoo.org/wp/?p=670#comment-2786115 In reply to Abhinay.

Hey Abhinay, Chandoo’s modified excel is basically my option 2 with minor change you can change url to simply “https://portal.amfiindia.com/spages/NAVAll.txt instead of referring the ‘nav location’. You can download the updated excel or if you have invested time in adding your data just update the power bi query with this.

]]> Comment on Mutual Fund Portfolio Tracker using MS Excel by Abhinay https://chandoo.org/wp/mutual-fund-portfolio-tracker-using-ms-excel/#comment-2786082 Sun, 23 Aug 2026 08:33:26 +0000 http://chandoo.org/wp/?p=670#comment-2786082 Chandoo, After I downloaded the modified template it still was giving me the same errors. I followed the Option1 suggested by Abhishek Mishra (Option 1:
Under Data ? Get Data ? Query Options ? Privacy ? Current Workbook, select Ignore privacy levels and potentially improve performance) and It worked.

I hope thats fine. Shall I continue using it? Or would incorporate the changes?

@Abhishek Mishra, Thanks for the help.

Thanks to all of you,

]]> Comment on Mutual Fund Portfolio Tracker using MS Excel by Srinivas G Y https://chandoo.org/wp/mutual-fund-portfolio-tracker-using-ms-excel/#comment-2786077 Sun, 23 Aug 2026 07:40:54 +0000 http://chandoo.org/wp/?p=670#comment-2786077 Hello Chandoo, That was really fast ..looks like it’s not throwing up the error. I will check this after trading hours tomorrow and confirm..
Thanks again for this lightnining response 🙂

cheers
Srini

]]> Comment on Mutual Fund Portfolio Tracker using MS Excel by Chandoo https://chandoo.org/wp/mutual-fund-portfolio-tracker-using-ms-excel/#comment-2786072 Sun, 23 Aug 2026 07:17:45 +0000 http://chandoo.org/wp/?p=670#comment-2786072 In reply to Krishna Prakash.

Please try to download the file again. I have fixed this error now.

]]> Comment on Mutual Fund Portfolio Tracker using MS Excel by Chandoo https://chandoo.org/wp/mutual-fund-portfolio-tracker-using-ms-excel/#comment-2786071 Sun, 23 Aug 2026 07:17:27 +0000 http://chandoo.org/wp/?p=670#comment-2786071 In reply to Srinivas G Y.

Please try the modified version here – https://chandoo.org/wp/wp-content/uploads/2026/08/mutual-fund-tracker-India-2026-v2.xlsx

]]> Comment on Mutual Fund Portfolio Tracker using MS Excel by Chandoo https://chandoo.org/wp/mutual-fund-portfolio-tracker-using-ms-excel/#comment-2786070 Sun, 23 Aug 2026 07:17:11 +0000 http://chandoo.org/wp/?p=670#comment-2786070 In reply to Ashok.

My bad. I had uploaded the file but did not adjust the link in the post. See here – https://chandoo.org/wp/wp-content/uploads/2026/08/mutual-fund-tracker-India-2026-v2.xlsx

]]> Comment on Mutual Fund Portfolio Tracker using MS Excel by Ashok https://chandoo.org/wp/mutual-fund-portfolio-tracker-using-ms-excel/#comment-2786069 Sun, 23 Aug 2026 07:11:34 +0000 http://chandoo.org/wp/?p=670#comment-2786069 Hi Chandoo,
Thank you for the quick response, unfortunately the 23 Aug file I am still getting the folling errors in the sequence below

1. “Query ‘NAVAIl’ (step AutoRemovedColumns1″) references other queres or steps, so it may not directly access a data source. Please rebuild this data combination.”
2. “Query NAVAIl (step “Sorted Rows’) references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.”

Appreciate your assistance to fix them.

]]>