Open Forum

Is anyone having issues exporting Smartlist to Excel? I have had no issues for the last 5 years up until last week.

THE PROBLEMS:

When exporting a Smartlist, the data in the rows goes to the wrong column if there are any blank column(s) at the beginning of the row.

Additionally, I'm having issues with returning a value in a cell when entering a formula. The formula just shows up as text in the cell. 

Any ideas what to look for? My partner recommended that I just change the first column to a column that always has data in it (like journal entry number). That works for getting the data in the correct column, but it doesn't always solve the problem of getting a value returned when entering a formula. I've checks the cell format to make sure it's formatted as a number but it still doesn't return a value.

I'm frustrated because it's been working for the last 5 years. We have not upgraded GP, so I'm not sure what is going on.

Any help would be greatly appreciated.

#smartlist export


​

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX
------------------------------

Hi @Deborah Butters

This seems odd.

I read that you have not upgraded or made changes to GP, but has your version of Excel Changed or your Microsoft licensing?

The inability to format the cell in Excel is the tip-off as that has nothing to do with GP.

Also, you could look into using Excel Refreshables as opposed to shooting a SmartList out to Excel.​

------------------------------
Jo deRuiter
🌟 GPUG AllStar 2019
💫Granite Award Winner 2018,2019
Atlanta Chapter Leader
Credential Council Co-Chair
Aisling Dynamics Consulting, LLC
ERP Practice Manager
jo.deruiter@aislingdynamics.com
9518674366
Alpharetta, GA
aislingdynamics.com
------------------------------

Original Message:
Sent: Nov 09, 2020 03:22 PM
From: Deborah Butters
Subject: Smartlist Export to Excel

Is anyone having issues exporting Smartlist to Excel? I have had no issues for the last 5 years up until last week.

THE PROBLEMS:

When exporting a Smartlist, the data in the rows goes to the wrong column if there are any blank column(s) at the beginning of the row.

Additionally, I'm having issues with returning a value in a cell when entering a formula. The formula just shows up as text in the cell.

Any ideas what to look for? My partner recommended that I just change the first column to a column that always has data in it (like journal entry number). That works for getting the data in the correct column, but it doesn't always solve the problem of getting a value returned when entering a formula. I've checks the cell format to make sure it's formatted as a number but it still doesn't return a value.

I'm frustrated because it's been working for the last 5 years. We have not upgraded GP, so I'm not sure what is going on.

Any help would be greatly appreciated.

#smartlist export

​

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX
------------------------------

Deborah,

It sounds like the way that SmartList exports to Excel could have been changed by a setting in the GP files.  Did you by chance add any lines to your Dex.ini file?  If you look in the installation folder for Dynamics GP and then the Data folder, you will find a file called Dex.ini.  Open it using Notepad and then see if you find either of the following lines.

• SmartlistEnhancedExcelExport=TRUE
• ExplorerFormatCurrency=FALSE

My guess is that maybe the first one is in there and that will change how your export happens and would cause the issues you are seeing.  You can try removing the line or changing it to FALSE and relaunching Dynamics GP and then see if that makes any difference on the export.

Let us know if what you find.


------------------------------
Nicole Albertson
Product Manager
eOne Solutions
------------------------------

Original Message:
Sent: Nov 09, 2020 03:22 PM
From: Deborah Butters
Subject: Smartlist Export to Excel

Is anyone having issues exporting Smartlist to Excel? I have had no issues for the last 5 years up until last week.

THE PROBLEMS:

When exporting a Smartlist, the data in the rows goes to the wrong column if there are any blank column(s) at the beginning of the row.

Additionally, I'm having issues with returning a value in a cell when entering a formula. The formula just shows up as text in the cell.

Any ideas what to look for? My partner recommended that I just change the first column to a column that always has data in it (like journal entry number). That works for getting the data in the correct column, but it doesn't always solve the problem of getting a value returned when entering a formula. I've checks the cell format to make sure it's formatted as a number but it still doesn't return a value.

I'm frustrated because it's been working for the last 5 years. We have not upgraded GP, so I'm not sure what is going on.

Any help would be greatly appreciated.

#smartlist export

​

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX
------------------------------

Thank you for your reply. I will have to contact my IT department or my GP partner to do this because I don't know how to access the the installation folder for Dynamics GP.

I had reached out to my partner and she said she could "try a behind the scenes fix, but it could make the actual export to excel process run slower."  Would that be true if we changed the Dex.ini file? 



------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX
------------------------------

Original Message:
Sent: Nov 10, 2020 09:25 AM
From: Nicole Albertson
Subject: Smartlist Export to Excel

Deborah,

It sounds like the way that SmartList exports to Excel could have been changed by a setting in the GP files.  Did you by chance add any lines to your Dex.ini file?  If you look in the installation folder for Dynamics GP and then the Data folder, you will find a file called Dex.ini.  Open it using Notepad and then see if you find either of the following lines.

• SmartlistEnhancedExcelExport=TRUE
• ExplorerFormatCurrency=FALSE

My guess is that maybe the first one is in there and that will change how your export happens and would cause the issues you are seeing.  You can try removing the line or changing it to FALSE and relaunching Dynamics GP and then see if that makes any difference on the export.

Let us know if what you find.


------------------------------
Nicole Albertson
Product Manager
eOne Solutions

Original Message:
Sent: Nov 09, 2020 03:22 PM
From: Deborah Butters
Subject: Smartlist Export to Excel

Is anyone having issues exporting Smartlist to Excel? I have had no issues for the last 5 years up until last week.

THE PROBLEMS:

When exporting a Smartlist, the data in the rows goes to the wrong column if there are any blank column(s) at the beginning of the row.

Additionally, I'm having issues with returning a value in a cell when entering a formula. The formula just shows up as text in the cell.

Any ideas what to look for? My partner recommended that I just change the first column to a column that always has data in it (like journal entry number). That works for getting the data in the correct column, but it doesn't always solve the problem of getting a value returned when entering a formula. I've checks the cell format to make sure it's formatted as a number but it still doesn't return a value.

I'm frustrated because it's been working for the last 5 years. We have not upgraded GP, so I'm not sure what is going on.

Any help would be greatly appreciated.

#smartlist export

​

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX
------------------------------

I have received warning from multiple directions that a recent Office update has really messed with functionality in GP and GP-related ISVs.  Because of this I have avoided installing that update in the GP user environment.  If you have installed a Office update you may want to have your IT staff uninstall it and see if the problem persists.

------------------------------
Jeff Frye
Systems Analyst
Hunt Brothers Pizza, LLC
Nashville TN
------------------------------

Original Message:
Sent: Nov 10, 2020 10:55 AM
From: Deborah Butters
Subject: Smartlist Export to Excel

Thank you for your reply. I will have to contact my IT department or my GP partner to do this because I don't know how to access the the installation folder for Dynamics GP.

I had reached out to my partner and she said she could "try a behind the scenes fix, but it could make the actual export to excel process run slower."  Would that be true if we changed the Dex.ini file?



------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX

Original Message:
Sent: Nov 10, 2020 09:25 AM
From: Nicole Albertson
Subject: Smartlist Export to Excel

Deborah,

It sounds like the way that SmartList exports to Excel could have been changed by a setting in the GP files.  Did you by chance add any lines to your Dex.ini file?  If you look in the installation folder for Dynamics GP and then the Data folder, you will find a file called Dex.ini.  Open it using Notepad and then see if you find either of the following lines.

• SmartlistEnhancedExcelExport=TRUE
• ExplorerFormatCurrency=FALSE

My guess is that maybe the first one is in there and that will change how your export happens and would cause the issues you are seeing.  You can try removing the line or changing it to FALSE and relaunching Dynamics GP and then see if that makes any difference on the export.

Let us know if what you find.


------------------------------
Nicole Albertson
Product Manager
eOne Solutions

Original Message:
Sent: Nov 09, 2020 03:22 PM
From: Deborah Butters
Subject: Smartlist Export to Excel

Is anyone having issues exporting Smartlist to Excel? I have had no issues for the last 5 years up until last week.

THE PROBLEMS:

When exporting a Smartlist, the data in the rows goes to the wrong column if there are any blank column(s) at the beginning of the row.

Additionally, I'm having issues with returning a value in a cell when entering a formula. The formula just shows up as text in the cell.

Any ideas what to look for? My partner recommended that I just change the first column to a column that always has data in it (like journal entry number). That works for getting the data in the correct column, but it doesn't always solve the problem of getting a value returned when entering a formula. I've checks the cell format to make sure it's formatted as a number but it still doesn't return a value.

I'm frustrated because it's been working for the last 5 years. We have not upgraded GP, so I'm not sure what is going on.

Any help would be greatly appreciated.

#smartlist export

​

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX
------------------------------

Deborah,

I am not sure what backend feature she is referring to. The "SmartlistEnhancedExcelExport=TRUE" line I referenced is something that when put in place does speed up your SmartList export to Excel, but has the downside of it removes some of the formatting and such that happens in the export to make it faster.  This is why my first instinct was to check for that line.  If it is removed or set to FALSE, the export will get slower, but it will export the data as is instead of having Excel try to pick up the formatting.


------------------------------
Nicole Albertson
Product Manager
eOne Solutions
------------------------------

Original Message:
Sent: Nov 10, 2020 10:55 AM
From: Deborah Butters
Subject: Smartlist Export to Excel

Thank you for your reply. I will have to contact my IT department or my GP partner to do this because I don't know how to access the the installation folder for Dynamics GP.

I had reached out to my partner and she said she could "try a behind the scenes fix, but it could make the actual export to excel process run slower."  Would that be true if we changed the Dex.ini file?



------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX

Original Message:
Sent: Nov 10, 2020 09:25 AM
From: Nicole Albertson
Subject: Smartlist Export to Excel

Deborah,

It sounds like the way that SmartList exports to Excel could have been changed by a setting in the GP files.  Did you by chance add any lines to your Dex.ini file?  If you look in the installation folder for Dynamics GP and then the Data folder, you will find a file called Dex.ini.  Open it using Notepad and then see if you find either of the following lines.

• SmartlistEnhancedExcelExport=TRUE
• ExplorerFormatCurrency=FALSE

My guess is that maybe the first one is in there and that will change how your export happens and would cause the issues you are seeing.  You can try removing the line or changing it to FALSE and relaunching Dynamics GP and then see if that makes any difference on the export.

Let us know if what you find.


------------------------------
Nicole Albertson
Product Manager
eOne Solutions

Original Message:
Sent: Nov 09, 2020 03:22 PM
From: Deborah Butters
Subject: Smartlist Export to Excel

Is anyone having issues exporting Smartlist to Excel? I have had no issues for the last 5 years up until last week.

THE PROBLEMS:

When exporting a Smartlist, the data in the rows goes to the wrong column if there are any blank column(s) at the beginning of the row.

Additionally, I'm having issues with returning a value in a cell when entering a formula. The formula just shows up as text in the cell.

Any ideas what to look for? My partner recommended that I just change the first column to a column that always has data in it (like journal entry number). That works for getting the data in the correct column, but it doesn't always solve the problem of getting a value returned when entering a formula. I've checks the cell format to make sure it's formatted as a number but it still doesn't return a value.

I'm frustrated because it's been working for the last 5 years. We have not upgraded GP, so I'm not sure what is going on.

Any help would be greatly appreciated.

#smartlist export

​

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX
------------------------------

That was the solution. Thank you for your help!

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX
------------------------------

Original Message:
Sent: Nov 10, 2020 01:54 PM
From: Nicole Albertson
Subject: Smartlist Export to Excel

Deborah,

I am not sure what backend feature she is referring to. The "SmartlistEnhancedExcelExport=TRUE" line I referenced is something that when put in place does speed up your SmartList export to Excel, but has the downside of it removes some of the formatting and such that happens in the export to make it faster.  This is why my first instinct was to check for that line.  If it is removed or set to FALSE, the export will get slower, but it will export the data as is instead of having Excel try to pick up the formatting.


------------------------------
Nicole Albertson
Product Manager
eOne Solutions

Original Message:
Sent: Nov 10, 2020 10:55 AM
From: Deborah Butters
Subject: Smartlist Export to Excel

Thank you for your reply. I will have to contact my IT department or my GP partner to do this because I don't know how to access the the installation folder for Dynamics GP.

I had reached out to my partner and she said she could "try a behind the scenes fix, but it could make the actual export to excel process run slower."  Would that be true if we changed the Dex.ini file?



------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX

Original Message:
Sent: Nov 10, 2020 09:25 AM
From: Nicole Albertson
Subject: Smartlist Export to Excel

Deborah,

It sounds like the way that SmartList exports to Excel could have been changed by a setting in the GP files.  Did you by chance add any lines to your Dex.ini file?  If you look in the installation folder for Dynamics GP and then the Data folder, you will find a file called Dex.ini.  Open it using Notepad and then see if you find either of the following lines.

• SmartlistEnhancedExcelExport=TRUE
• ExplorerFormatCurrency=FALSE

My guess is that maybe the first one is in there and that will change how your export happens and would cause the issues you are seeing.  You can try removing the line or changing it to FALSE and relaunching Dynamics GP and then see if that makes any difference on the export.

Let us know if what you find.


------------------------------
Nicole Albertson
Product Manager
eOne Solutions

Original Message:
Sent: Nov 09, 2020 03:22 PM
From: Deborah Butters
Subject: Smartlist Export to Excel

Is anyone having issues exporting Smartlist to Excel? I have had no issues for the last 5 years up until last week.

THE PROBLEMS:

When exporting a Smartlist, the data in the rows goes to the wrong column if there are any blank column(s) at the beginning of the row.

Additionally, I'm having issues with returning a value in a cell when entering a formula. The formula just shows up as text in the cell.

Any ideas what to look for? My partner recommended that I just change the first column to a column that always has data in it (like journal entry number). That works for getting the data in the correct column, but it doesn't always solve the problem of getting a value returned when entering a formula. I've checks the cell format to make sure it's formatted as a number but it still doesn't return a value.

I'm frustrated because it's been working for the last 5 years. We have not upgraded GP, so I'm not sure what is going on.

Any help would be greatly appreciated.

#smartlist export

​

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX
------------------------------

Hello Nicole,

Since you were able to help me on this issue, I'm reaching out to you on a similar issue. I have a Smartlist I'm trying to export to excel but when I do, it is creating a column that is a numberic value to a column that has computed values in excel. The cells have a green triangle in the top left corner. When I try to format the cell to a number, it doesn't do anything. Any ideas what's going on?

Debbie

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX
------------------------------

Original Message:
Sent: Nov 10, 2020 01:54 PM
From: Nicole Albertson
Subject: Smartlist Export to Excel

Deborah,

I am not sure what backend feature she is referring to. The "SmartlistEnhancedExcelExport=TRUE" line I referenced is something that when put in place does speed up your SmartList export to Excel, but has the downside of it removes some of the formatting and such that happens in the export to make it faster.  This is why my first instinct was to check for that line.  If it is removed or set to FALSE, the export will get slower, but it will export the data as is instead of having Excel try to pick up the formatting.


------------------------------
Nicole Albertson
Product Manager
eOne Solutions

Original Message:
Sent: Nov 10, 2020 10:55 AM
From: Deborah Butters
Subject: Smartlist Export to Excel

Thank you for your reply. I will have to contact my IT department or my GP partner to do this because I don't know how to access the the installation folder for Dynamics GP.

I had reached out to my partner and she said she could "try a behind the scenes fix, but it could make the actual export to excel process run slower."  Would that be true if we changed the Dex.ini file?



------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX

Original Message:
Sent: Nov 10, 2020 09:25 AM
From: Nicole Albertson
Subject: Smartlist Export to Excel

Deborah,

It sounds like the way that SmartList exports to Excel could have been changed by a setting in the GP files.  Did you by chance add any lines to your Dex.ini file?  If you look in the installation folder for Dynamics GP and then the Data folder, you will find a file called Dex.ini.  Open it using Notepad and then see if you find either of the following lines.

• SmartlistEnhancedExcelExport=TRUE
• ExplorerFormatCurrency=FALSE

My guess is that maybe the first one is in there and that will change how your export happens and would cause the issues you are seeing.  You can try removing the line or changing it to FALSE and relaunching Dynamics GP and then see if that makes any difference on the export.

Let us know if what you find.


------------------------------
Nicole Albertson
Product Manager
eOne Solutions

Original Message:
Sent: Nov 09, 2020 03:22 PM
From: Deborah Butters
Subject: Smartlist Export to Excel

Is anyone having issues exporting Smartlist to Excel? I have had no issues for the last 5 years up until last week.

THE PROBLEMS:

When exporting a Smartlist, the data in the rows goes to the wrong column if there are any blank column(s) at the beginning of the row.

Additionally, I'm having issues with returning a value in a cell when entering a formula. The formula just shows up as text in the cell.

Any ideas what to look for? My partner recommended that I just change the first column to a column that always has data in it (like journal entry number). That works for getting the data in the correct column, but it doesn't always solve the problem of getting a value returned when entering a formula. I've checks the cell format to make sure it's formatted as a number but it still doesn't return a value.

I'm frustrated because it's been working for the last 5 years. We have not upgraded GP, so I'm not sure what is going on.

Any help would be greatly appreciated.

#smartlist export

​

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX
------------------------------

Hey Deborah, I know what is causing that little triangle you see.  I have noticed before that when Smartlist exports to excel some columns like numeric or date formatted columns are not sent with the formatting you expect rather they are sent as text values and not actual numeric values.  What you are seeing is that a character like an apostrophe is placed in front of the value and that makes that small green triangle appear and thus you wont be able to format that as a number as Excel does not yet see it as a number.  You can try this yourself as a test by opening a new spreadsheet and enter the number '205 with the apostrophe like i show you here, and then hit enter then in the next cell enter 205 and hit enter one more time.  You should notice a difference and this is what is happening to your numbers.  There is an easy fix however, you just need to highlight the entire column where you see the triangles and do the following:  Highlight the column>>choose from the Menus Data>>then the Text to Columns button>>Click Finish.  And its fixed.  Normally, this wizard splits data into multiple columns during import but it can be used like this also to make a single column convert from Text entered values to actual Numbers.  Good luck and hope this suggestion helps.


------------------------------
Tracy Hipps
TD Carpenter & Associates, Inc.
Toledo OH
------------------------------

Original Message:
Sent: Jul 23, 2021 05:47 PM
From: Deborah Butters
Subject: Smartlist Export to Excel

Hello Nicole,

Since you were able to help me on this issue, I'm reaching out to you on a similar issue. I have a Smartlist I'm trying to export to excel but when I do, it is creating a column that is a numberic value to a column that has computed values in excel. The cells have a green triangle in the top left corner. When I try to format the cell to a number, it doesn't do anything. Any ideas what's going on?

Debbie

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX

Original Message:
Sent: Nov 10, 2020 01:54 PM
From: Nicole Albertson
Subject: Smartlist Export to Excel

Deborah,

I am not sure what backend feature she is referring to. The "SmartlistEnhancedExcelExport=TRUE" line I referenced is something that when put in place does speed up your SmartList export to Excel, but has the downside of it removes some of the formatting and such that happens in the export to make it faster.  This is why my first instinct was to check for that line.  If it is removed or set to FALSE, the export will get slower, but it will export the data as is instead of having Excel try to pick up the formatting.


------------------------------
Nicole Albertson
Product Manager
eOne Solutions

Original Message:
Sent: Nov 10, 2020 10:55 AM
From: Deborah Butters
Subject: Smartlist Export to Excel

Thank you for your reply. I will have to contact my IT department or my GP partner to do this because I don't know how to access the the installation folder for Dynamics GP.

I had reached out to my partner and she said she could "try a behind the scenes fix, but it could make the actual export to excel process run slower."  Would that be true if we changed the Dex.ini file?



------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX

Original Message:
Sent: Nov 10, 2020 09:25 AM
From: Nicole Albertson
Subject: Smartlist Export to Excel

Deborah,

It sounds like the way that SmartList exports to Excel could have been changed by a setting in the GP files.  Did you by chance add any lines to your Dex.ini file?  If you look in the installation folder for Dynamics GP and then the Data folder, you will find a file called Dex.ini.  Open it using Notepad and then see if you find either of the following lines.

• SmartlistEnhancedExcelExport=TRUE
• ExplorerFormatCurrency=FALSE

My guess is that maybe the first one is in there and that will change how your export happens and would cause the issues you are seeing.  You can try removing the line or changing it to FALSE and relaunching Dynamics GP and then see if that makes any difference on the export.

Let us know if what you find.


------------------------------
Nicole Albertson
Product Manager
eOne Solutions

Original Message:
Sent: Nov 09, 2020 03:22 PM
From: Deborah Butters
Subject: Smartlist Export to Excel

Is anyone having issues exporting Smartlist to Excel? I have had no issues for the last 5 years up until last week.

THE PROBLEMS:

When exporting a Smartlist, the data in the rows goes to the wrong column if there are any blank column(s) at the beginning of the row.

Additionally, I'm having issues with returning a value in a cell when entering a formula. The formula just shows up as text in the cell.

Any ideas what to look for? My partner recommended that I just change the first column to a column that always has data in it (like journal entry number). That works for getting the data in the correct column, but it doesn't always solve the problem of getting a value returned when entering a formula. I've checks the cell format to make sure it's formatted as a number but it still doesn't return a value.

I'm frustrated because it's been working for the last 5 years. We have not upgraded GP, so I'm not sure what is going on.

Any help would be greatly appreciated.

#smartlist export

​

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX
------------------------------

Original Message:
Sent: 1/18/2023 5:08:00 PM
From: Tracy Hipps
Subject: RE: Smartlist Export to Excel

Hey Deborah, I know what is causing that little triangle you see.  I have noticed before that when Smartlist exports to excel some columns like numeric or date formatted columns are not sent with the formatting you expect rather they are sent as text values and not actual numeric values.  What you are seeing is that a character like an apostrophe is placed in front of the value and that makes that small green triangle appear and thus you wont be able to format that as a number as Excel does not yet see it as a number.  You can try this yourself as a test by opening a new spreadsheet and enter the number '205 with the apostrophe like i show you here, and then hit enter then in the next cell enter 205 and hit enter one more time.  You should notice a difference and this is what is happening to your numbers.  There is an easy fix however, you just need to highlight the entire column where you see the triangles and do the following:  Highlight the column>>choose from the Menus Data>>then the Text to Columns button>>Click Finish.  And its fixed.  Normally, this wizard splits data into multiple columns during import but it can be used like this also to make a single column convert from Text entered values to actual Numbers.  Good luck and hope this suggestion helps.


------------------------------
Tracy Hipps
TD Carpenter & Associates, Inc.
Toledo OH
------------------------------

Original Message:
Sent: Jul 23, 2021 05:47 PM
From: Deborah Butters
Subject: Smartlist Export to Excel

Hello Nicole,

Since you were able to help me on this issue, I'm reaching out to you on a similar issue. I have a Smartlist I'm trying to export to excel but when I do, it is creating a column that is a numberic value to a column that has computed values in excel. The cells have a green triangle in the top left corner. When I try to format the cell to a number, it doesn't do anything. Any ideas what's going on?

Debbie

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX

Original Message:
Sent: Nov 10, 2020 01:54 PM
From: Nicole Albertson
Subject: Smartlist Export to Excel

Deborah,

I am not sure what backend feature she is referring to. The "SmartlistEnhancedExcelExport=TRUE" line I referenced is something that when put in place does speed up your SmartList export to Excel, but has the downside of it removes some of the formatting and such that happens in the export to make it faster.  This is why my first instinct was to check for that line.  If it is removed or set to FALSE, the export will get slower, but it will export the data as is instead of having Excel try to pick up the formatting.


------------------------------
Nicole Albertson
Product Manager
eOne Solutions

Original Message:
Sent: Nov 10, 2020 10:55 AM
From: Deborah Butters
Subject: Smartlist Export to Excel

Thank you for your reply. I will have to contact my IT department or my GP partner to do this because I don't know how to access the the installation folder for Dynamics GP.

I had reached out to my partner and she said she could "try a behind the scenes fix, but it could make the actual export to excel process run slower."  Would that be true if we changed the Dex.ini file?



------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX

Original Message:
Sent: Nov 10, 2020 09:25 AM
From: Nicole Albertson
Subject: Smartlist Export to Excel

Deborah,

It sounds like the way that SmartList exports to Excel could have been changed by a setting in the GP files.  Did you by chance add any lines to your Dex.ini file?  If you look in the installation folder for Dynamics GP and then the Data folder, you will find a file called Dex.ini.  Open it using Notepad and then see if you find either of the following lines.

• SmartlistEnhancedExcelExport=TRUE
• ExplorerFormatCurrency=FALSE

My guess is that maybe the first one is in there and that will change how your export happens and would cause the issues you are seeing.  You can try removing the line or changing it to FALSE and relaunching Dynamics GP and then see if that makes any difference on the export.

Let us know if what you find.


------------------------------
Nicole Albertson
Product Manager
eOne Solutions

Original Message:
Sent: Nov 09, 2020 03:22 PM
From: Deborah Butters
Subject: Smartlist Export to Excel

Is anyone having issues exporting Smartlist to Excel? I have had no issues for the last 5 years up until last week.

THE PROBLEMS:

When exporting a Smartlist, the data in the rows goes to the wrong column if there are any blank column(s) at the beginning of the row.

Additionally, I'm having issues with returning a value in a cell when entering a formula. The formula just shows up as text in the cell.

Any ideas what to look for? My partner recommended that I just change the first column to a column that always has data in it (like journal entry number). That works for getting the data in the correct column, but it doesn't always solve the problem of getting a value returned when entering a formula. I've checks the cell format to make sure it's formatted as a number but it still doesn't return a value.

I'm frustrated because it's been working for the last 5 years. We have not upgraded GP, so I'm not sure what is going on.

Any help would be greatly appreciated.

#smartlist export

​

------------------------------
Deborah Butters
Valley Coop Oil Mill
Harlingen TX
------------------------------