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?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.