on 05-07-2009 2:02 PM
HI all,
I have a customer who is having troubles on just one workstation with Export to Excel not Auto Opening.
I have already went in and made sure that he is saving to the right path, that the autoopen.xls file is in that location, and I have also made sure that the macros are allowing the content.
If anyone has any other suggestions that would be great. Thanks in advance.
Best Regards,
Jeff Haldeman
Support One
Edited by: Jeff Haldeman on May 7, 2009 8:03 AM
Actually, all 863-29 errors are related to file authorization somehow. Have you checked if any other users can auto open at that workstation?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Gordon
As for the first thread we have already established that the user has full access to the folder that she is trying to save in. As for the second thread I'm not really sure what the resolution is in that thread. If you could give me some more information on what that thread actually contains for a solution then I will let you know for sure if we have tried that. Thanks!
Jeff
In Excel, make sure that under "Tools -> Macro ->Security -> Trusted Publishers tab" that the "Trust access to Visual Basic Project" selection is checkmarked. The "Trust all installed add-ins and templates" should also be checked.
This corrected the same issue at my site.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To all,
Thank you for the helpful replies above. Unfortunetly the end user has tried all of these steps and is still unable to export to excel on one workstation. If you have any other ideas that would be greatly appreciated.If I get any updated information from my end user i will post it on here at that time. Once again thank you for the help.
Regards,
Jeff Haldeman
Support One
Do a simple test,
With Explorer see if you can explore to the Server ie.
sap\
If it prompts you for Userid and Password that's your problem, you must have a link established between the client and the server.
If you enter your userid and password it will display the folders, then go back to export to excel and it will work.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Auto Opening issue for export to Excel is mostly due to user authorization problem. You can verify it easily by using this user's account to check property of AutoOpen.xls file in the right path. It must not have read only status ticked.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.