Skip to content
Pardaan.com Pardaan.com

Work becomes effortless when driven by passion...

  • Home
  • Profile
  • Tags
  • LinkedIn
  • Facebook
  • X

excel

  • Home
  • excel
Posted inDynamics NAV & BC Tips & tricks

I have never seen Business Central integrate with Excel like this!

Join me in a hack to explore a different type of integration between Business Central Excel. I spend a few days on a kind of “what if” exercise, check out the result in this video: Source : Hougaard.com Read more...
Read More
26 June 2024
Posted inDynamics NAV & BC Tips & tricks

Take Control of Your Data with Excel Report Layouts in Business Central

The 2024 Wave 1 release of Dynamics 365 Business Central made enhancements to Excel report layouts, letting users and developers create their own Excel layouts for reporting. This new feature goes beyond exporting data to Excel, which has been available since the Dynamics NAV days. Instead,…
Read More
14 May 2024
Posted inDynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: Switching environments and companies directly in the Edit in Excel file

Today I would like to share another mini tip about Business Central, how to switch environments and companies directly in the Edit in Excel file. Source : Dynamics 365 Lab Read more...
Read More
18 July 2023
Posted inDynamics NAV & BC Tips & tricks

7 Excel Tips For Business Central

Excel is one of the most used tools worldwide. In this post, you will learn 7 tips to export data from Business Central to Microsoft Excel. Also, you will learn how to connect OData Feed and Power Automate to Business Central. Source : Business Central Geek…
Read More
6 June 2023
Posted inDynamics NAV & BC Tips & tricks

D365 Business Central : Using Excel Layout for Reporting

Since Business Central 2022 Wave 1 (BC20), we have the ability to use Excel Layout for reporting. Excel layouts work the same way as Word and RDLC layouts in that they can be edited and saved back again into Business Central. With Excel layouts for Business…
Read More
1 September 2022
Posted inDynamics NAV & BC Tips & tricks

Excel Reports – something new in reporting space

Last week I have been exploring the Excel Layouts which are a brand new feature in Business Central version 20 (Wave 1 2022). I did not only watch the video from the Launching Event, but I also developed one of the reports. If you want to…
Read More
12 May 2022
Posted inDynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: How to disable “Edit in Excel” on a specific page

With pages in Business Central that display a list of records in rows and columns, like a list of items, sale orders, or invoices, you can export the list to Microsoft Excel, and view it there. Depending on the page, you have two options for viewing…
Read More
10 May 2022

Posts pagination

1 2 3 … 18 Next page

Menu
  • Profile
  • Tags
Categories
  • Data & Analysis
  • Dynamics NAV & BC
    • Functional
    • General
    • Technical
    • Tips & tricks
  • ERP general
  • Information management
  • Off-topic
  • Projectmanagement
  • Quote of the week
  • Visual C# / ASP.net
Stay Hungry, Stay Foolish
RSS Mibuso
  • Report on a JobQueue sais execute is ok but when i check the changes it didnt do anyting
  • GST TDS on Purchase in indian localisation
  • Accessing NAV in RTC but no Companies
  • <solved> Sending Mails via Outlook and Excel-Export don't work
  • <solved> Passing parameters to a request page from another object (in AL)
  • Common ?? (seemingly no answer) - The request was aborted: Could not create SSL/TLS secure channel
  • send email with pdf attachment Business Central Cloud
  • Printing from NAV 2015 to Outlook - Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT))
  • How to call a procedure in Business Central from Power Automate
  • How to transfer custom field from service order , service line (items) to Warehouse Entry Table
  • Advice needed: Switching to AL-GO Github?
  • "all of your selections were processed" BC message
  • How to implement OIOUBL 2.1 in NAV 2017 (codeunit 13609)
  • Missing Codeunit 9998 and 9999 of Upgrade Routine NAV2017 to BC 14 Spring 19
  • How can I change my Mibuso E-mail address in my user profile?
  • Tenant Media
  • Amount on Check Ledger Entry does not match amount on Bank Account Ledger Entry
  • GST calculation issue
  • To provide Vendor Payment Bank upload file
  • Deepinserts not working
RSS Dynamics NAV Team Blog
  • Smarter callbacks with availability-aware scheduling CCaaS APIs
  • AI in sales: Applying historical lessons to modern challenges 
  • Get started with agents for finance: Learnings from 2025 Gartner® CFO & Finance Executive Conference
  • The power of proactive engagement in Dynamics 365 Contact Center
  • Seamless scheduling across time zones in Dynamics 365 Field Service
  • Explore migration options for Microsoft Dynamics GP and Microsoft Dynamics SL customers
  • Unlock the power of record routing with real-time analytics
  • Agentic CRM systems: Learnings from organizations making the switch
  • Under the Hood: Building an AI-Driven Storefront with Dynamics 365 Commerce 
  • AI-powered proactive engagement and conversational journeys with Microsoft Dynamics 365 in public preview
RSS Power BI
  • Updates to Copilot in Power BI: More ways to see, learn from, and ask about your report data
  • Expanded entry points, access options, and functionality in Explore
  • Celebrate with us as Power BI Turns 10!
  • Microsoft named a Leader in the 2025 Gartner® Magic Quadrant™ for Analytics and BI Platforms
  • Open and edit any semantic model with Power BI tools
  • Power BI June 2025 Feature Summary
  • What’s New in SQL Server 2025 Analysis Services
  • Now available: two new Copilot experiences
  • Your Road to Power BI Certification Starts Here
  • Power BI Report Server May 2025 Feature Summary
Scroll to Top