Hello I am a new user at my job to SAS VA and have created a basic report in VA. In excel I have the SAS VA add-in. I open up a file I have been working on which has a tab where I have my data set to drive some charts and graphs. Rather then copy and paste this data from VA, I want to connect to the report so that I can always have it linked and quickly refresh my data. I go to reports, connect to my data source, find the report I built and click insert onto the tab I want to keep the data in however I get the following error: Unable to set the NumberFormat property of the Range class Exception type: System.Runtime.InteropServices.COMException Message: Unable to set the NumberFormat property of the Range class Source: Microsoft Excel Target Site: ForwardCallToInvokeMember Help Link: xlmain11.chm Whats strange is that it only happens with the file I am working in. If I make a new/clean tab in this file and try to import data, I get the error. This blows my mind because its a new tab with no formatting what so ever. If I create a whole new file, the data imports fine. What could be the issue with this file that the Add-In does not like some formatting on one of the tabs? Thanks Joe
... View more