BookmarkSubscribeRSS Feed
FredrikE
Rhodochrosite | Level 12
I am using excel and my users want a predesigned excelsheet with the most common choises already there.
I make the sheet and check "refresh on open" and uncheck "save password", and finally saves it to disc.

The problem occur when a user (or anyone) open the excelfile, they get prompted to log in, but if they choose to cancel they come to excel with the figures that was saved by me.

I want the figures to be blanked or not displayed until the user logs in.

Do anyone have a solution/work around for this?
1 REPLY 1
DavidHenderson
SAS Employee
In the current design, if the refresh is aborted for any reason before results are retrieved, the current contents of the document are not cleared.

The only suggestion I have as a work around would be to write a bit of VBA code to clear the portion of the document when it is opened by the user.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 1 reply
  • 699 views
  • 0 likes
  • 2 in conversation