[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • Last Modified:

C# - Client Clicks on "Enable Editing" in Excel and is asked to Log In

I have a website which uses Crystal Reports to generate an excel spreadsheet.  The user clicks on a link that opens the report.  If the user saves the report there are no issues.  If the user opens the report the user sees their data.  If the user decides to click on "Enable Editing" the spreadsheet then will then display the login page of the website for them to login.

It seems that excel wants them to authenticate.

Any idea why and how to stop?

Thanks
0
CipherIS
Asked:
CipherIS
  • 2
  • 2
1 Solution
 
mlmccCommented:
When they click to enable editing how are you allowing that?

SInce the spreadsheet is on the website, they have to verified before being allowed to potentially change something.

mlmcc
0
 
CipherISAuthor Commented:
They use their browser to access our website.  They click on a link that downloads an excel file which was generated.  It gives them two options (1) Save or (2) Open.  If they click on save there are no issues.  When they click on open they see the data.  

It is using MS Office from their local machine.  When it is open the "Enable Editing" is displayed.  It is an inherent feature of MS Office.  When they click on Enable Editing that is when they are asked to log in.
0
 
mlmccCommented:
If they save to their machine then click enable the permission to edit the file is handled locally and they have permission to write to the location of the file.  However if they open it from the website it probably depends on where the temporary file is stored that determines the permissions to change.

mlmcc
0
 
CipherISAuthor Commented:
Is there anyway to prevent it from having to login?  From ensuring that it is local to their machine when they download?
0
 
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now