In Smartview options - go to Data Options - Replacement sections and there see the Value set for #NoData/Missing Label - check what value it has if it has #Name edit and replace with None.
We have just experienced the same issue. We had a few error messages about folder security and access so we ended up making the C:\Oracle\SmartView\Bin folder a Trusted Location in Excel. Here are the instructions we wrote up for our use.
When installing Smart View 64-bit, make the C:\Oracle\SmartView\Bin folder a trusted site by going through the following.
In Excel go to File/Options/Trust Center.
Click on Trust Center Settings/Trusted Locations then Add new location… and browse to the Bin folder.
Current value for #NoData/Missing Label is set to #Missing. Drop-down options include: #Missing and #NumericZero only.
I changed value to #NumericZero. Refreshed the worksheet, but still #Name? value appears.
I have added C:\Oracle\SmartView\bin\ under the Trusted Locations in Excel. But still same error appears in the smartview file.
#NAME - This error occurs when Microsoft Excel doesn't recognize text in a formula. When you forward a spreadsheet that contains functions to a user who does not have Smart View, users can view the same data as the functions remain displayed on the spreadsheet. When the user edits the function or selects Refresh, the function changes to #Name.
Please clear all the formula and functions attached with the excel and then retrive.
also checkuout below archibed forum as well.