topic Using excel to access SAS OLAP cubes in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-excel-to-access-SAS-OLAP-cubes/m-p/1274#M79 I am using excel and my users want a predesigned excelsheet with the most common choises already there. <BR /> I make the sheet and check "refresh on open" and uncheck "save password", and finally saves it to disc. <BR /> <BR /> 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. <BR /> <BR /> I want the figures to be blanked or not displayed until the user logs in. <BR /> <BR /> Do anyone have a solution/work around for this? Thu, 17 Aug 2006 13:57:30 GMT FredrikE 2006-08-17T13:57:30Z Using excel to access SAS OLAP cubes https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-excel-to-access-SAS-OLAP-cubes/m-p/1274#M79 I am using excel and my users want a predesigned excelsheet with the most common choises already there. <BR /> I make the sheet and check "refresh on open" and uncheck "save password", and finally saves it to disc. <BR /> <BR /> 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. <BR /> <BR /> I want the figures to be blanked or not displayed until the user logs in. <BR /> <BR /> Do anyone have a solution/work around for this? Thu, 17 Aug 2006 13:57:30 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-excel-to-access-SAS-OLAP-cubes/m-p/1274#M79 FredrikE 2006-08-17T13:57:30Z Re: Using excel to access SAS OLAP cubes https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-excel-to-access-SAS-OLAP-cubes/m-p/1275#M80 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.<BR /> <BR /> 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. Fri, 19 Jan 2007 16:14:53 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-excel-to-access-SAS-OLAP-cubes/m-p/1275#M80 DavidHenderson 2007-01-19T16:14:53Z