RE: Best Tool to Export multiple tables to one Excel spread sheet on a workstation and not in Development Enviornment
Alexander has some good suggestions. If you are looking to export data to Excel and wish to be able to refresh the Excel spreadsheet subsequently, I would recommend looking into using one of the following options:
Option 1: Jet Express from JetReports (you get it for free if you have NAV 2009 R2 or newer)
Once installed and configured, you can use the Table Wizard to get data from one or multiple NAV tables (as a view) into one spreadsheet. You can easily refresh this with the push of a button. It is very user friendly and intuitive. Check out this video for a quick example: https://www.youtube.com/watch?v=EtGtZzbjSdo (the Table wizard is shown around the 35 second mark).
Option 2: Use Web Services in NAV to expose data and access it in Excel using OData
This takes a couple steps but will not require anything besides NAV and Excel. Go to Web Services, and create one or more new web services for the Pages from which you wish to get data in Excel. Publish the web service(s) and copy their OData URLs to a notepad.
In Excel, go to the Data tab, Get External Data > From Other Sources > From OData Data feed, and here, enter the OData URL for your first web service, enter credentials, and follow the steps to completion. Repeat the process for each additional web service you have created in NAV. You can refresh the data in this file by clicking on Refresh All from the Data tab in Excel. Use Pivot Tables to combine data as needed. If you have access to PowerPivot in Excel, it's even more powerful and easier to get data from OData feeds and model it.
I hope this helps! If it has, please take a moment to verify the answer by clicking on Yes next to "Does this answer your question?"