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?