Microsoft Office Excel cannot access files or com

Source: Internet
Author: User
Microsoft Office Excel cannot access files or com, Microsoft Office Excel cannot access files "*. xls ". Possible causes: 1. The file name or path does not exist. 2 files are being used by other programs. 3. The workbook you want to save has the same name as the one currently opened.

An inexplicable error occurs. debugging on the local machine is normal, but once deployed on the server, it cannot be accessed ......

I checked some information and found that everyone encountered this problem.

Solution

In c: \ windows \ system32 \ config \ systemprofile and C: \ windows \ syswow64 \ config \ systemprofile create a directory named desktop to solve the problem that cannot be accessed by COM components. Solution: 1. 1 ). add the simulation in webconfig and add the Administrator permission. <identity impersonate = "true" username = "System Administrator" Password = "system administrator password"/> 2 ). in this way, you can start the application process, operate on Excel, and create and export Excel files. However, you still cannot open Excel files on the server.
2. in the component service, docm sets the properties of Microsoft Excel application. Because the operation is performed on a 64-bit system, docom does not exist in the component service by default, because Microsoft Excel application is a 32 DCOM configuration, you can solve it as follows (refer to Step 3. 1 ). start --> Run --> cmd 2) Enter comexp at the command prompt. MSC-32, open the 32 console 3 ). in the File menu, add or delete a management unit --> component service 4 ). in "DCOM configuration", find "Microsoft Excel application", right-click it, and then click "properties". The "Microsoft Excel application properties" dialog box is displayed. 5 ). click the "ID" tab and select "Interactive User" 6 ). click the "Security" tab, click "Custom" on "Start and activate Permissions", and then click the corresponding "edit" button, in the pop-up "security" dialog box, add a "Network Service" user (Be sure to select the computer name ), and grant it the "local startup" and "Local activation" permissions 7 ). still "security" label, click "Custom" on "Access Permissions", and then click "edit ", in the pop-up "security" dialog box, add a "Network Service" user and grant "local access" permission.

4. Restart IIS and pass the test.

For iis7 + win2008 R2, modify the preceding attributes in the Excel application of the component service.

Microsoft Office Excel cannot access files or com

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.