Hyperion Smart View Add-In and Protected sheets

[mdjks]

I created a form for my company's travel expense reporting and have password protected it. There is a small group of users who are having a problem using the form and our helpdesk informed them that the problem was due to having the Hyperion Smart View Add-In installed, see comment below.

Hyperion Smart View For Office (Tools  Add-Ins  Hyperion Smart View For Office[see below]). We us this when accessing financial data and although better than clicking cancel 13 times, having to disable it every time you want to save an expense report is not a solution.

Has anyone had a simalar experiance?

Due to legal compliance issues I cannot give them an unprotected form.

Users have Excel 2003

 

[Bilbo_Baggins_Esq]

I'll hazard a guess that you'll need to examine your form code for why it is calling anything related to what the Hyperion Add-in also uses.

It would help us to see the code and the specific errors.

I've never tried it, but it may be possible to use code to briefly disable the Hyperion Add-in with your Form code for the duration of the form usage and then re-enable it with more code as the form is completing its run.

 

[mdjks]

This is really a workbook with linked cells to do travel expenses in, I should not have called it a form. The only code in the multi sheet workbook is a simple macro that clears existing data if the user chooses or leaves it alone so they can continue filling out their expense report.

I would like to give your suggestion about disabling the add-in a shot but in the interim have told the users that they will need to manually disable it.

The users description of the issue is all I have:

I entered my data to make a template so I don't have to input it every time I do a report. Every time I "save as" The password window pops up and I have to hit cancel 13 times before I can save it. I just tried it again with no data and did 6 reports this week and had the same problem every time. The only time it does not do it is if I close Excel (click x in top right corner) without saving, it will pop up and ask if I want to save changes.​

I do not have the hyperion add-in since I do not use hyperion and couldn't find a way to load it (honestly didn't look too hard) so I can't recreate the problem for testing. I did find some internal people with the addin who do get the same error.

 

[Bilbo_Baggins_Esq]

Well, as the developer, I'd be getting the Add-in so I could troubleshoot the issue and test solution(s).
The difference is between sending a workbook out that you "think" might work, or one that you "know" works.

Without more specifics, I'm not sure how much we can do for you.

You could copy the completed worksheet to a new workbook and save it with a defined name with the password and then close the original workbook without saving changes.
But the you may hit the same wall as the user is when doing a manual save as. Without the add-in, the errors, or the code, who knows if more errors will ensue after the password is supplied.