CSV exported data shows #NAME? in Excel

  • 7011064
  • 12-Apr-2011
  • 19-Oct-2012

Resolution

Question:

When I export CSV data from an Access Governance Suite report and open the csv file with Excel, the data displays as #NAME? instead of the actual data.

The data in question starts with a hypen (Ex: "- some data here").

Answer:

Excel believes this data is an incomplete formula (subtraction). If you examine the exported csv data in a text editor (Notepad for example) you will see the exported Access Governance Suite data is correct.