-
Hi, Is there a way to fix the width of the cell in excel? Scenario: 1. I create a report that get the template in Excel file. 2. Use the template to populate the data base on the excel template. 3. But when send all the data to excel it, ruined the template because the cell is expanding, so I want to...
-
Hi Greg, Depending on the report and the complexity there are a number of options: 1. No codeing bt messy output - In the preview window of the report select File -> Save as HTML. Then open the HTML file in Excel 2. The way most report are coded - Nav use a table 370 Excel Buffer for Excel input/output...
-
Hi, We're running NAV 5.0 SP1. I'm new to this forum, so please don't shoot me, if this question is too easy or filed in the wrong section. I want to open an Excel file by clicking on an item in the navigation panel in NAV. I don't need data to be exported or linked. I just need to access...
-
Hi all We have a problem on some computers when exporting a sales quotation to Word or Excel. I cannot find any information regarding this scenario and the Event Log does not have a description for the error. The log entry is as follows: Event Type: Error Event Source: Microsoft Dynamics NAV Event Category...
-
That`s new approach of Excel 2007... There are three new formats for Excel files: .XSLX - default format, used for simple calculations (formulas), which doesn`t support macros AT ALL for security reasons - if you know you won`t need macros, you can use this format and a macro virus PHYSICALLY cannot...
-
Hi Chris, First welcome to the user group. We hope we can help you. But first we need to know how you are actually exporting the report from NAV to Excel 2007. Except for a few reports (ex. Budgets) then there are not many other. Or is it a customized report? The standard reports are opening Excel with...
-
Hello, First post in this community, glad to be here. We have a report that exports a summary from NAV to Excel 2007. We wish to run a macro to format the report however all macro functionality is disabled in the instance of Excel that is called up. Our partner thinks it may be opening Excel through...
-
Hi, Is there a way to fix the width of the cell in excel? Scenario: 1. I create a report that get the template in Excel file. 2. Use the template to populate the data base on the excel template. 3. But when send all the data to excel it, ruined the template because the cell is expanding, so I want to...
-
Hi Greg, Depending on the report and the complexity there are a number of options: 1. No codeing bt messy output - In the preview window of the report select File -> Save as HTML. Then open the HTML file in Excel 2. The way most report are coded - Nav use a table 370 Excel Buffer for Excel input/output...
-
Hi, We're running NAV 5.0 SP1. I'm new to this forum, so please don't shoot me, if this question is too easy or filed in the wrong section. I want to open an Excel file by clicking on an item in the navigation panel in NAV. I don't need data to be exported or linked. I just need to access...