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.
#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.