I am getting the following error "Error: You are attempting to open a file that is blocked by your File block settings in the Trust Center.,;in line 27" with PDF to Excel Converter v2.0 and Excel 2013

Hi

I am using trial version, downloaded this morning.

When I try to convert a batch of pdf files, I am getting the following error

"Error: You are attempting to open a file that is blocked by your File block settings in the Trust Center.,;in line 27"

The message repeats for each of the files in the batch.

I am using Excel 2013

Customer
-------------------------------------

I am using VeryPDF to Excel Converter v2.0 and Excel 2013.

Customer
-------------------------------------
We suggest you may use Administrator privilege to run VeryPDF to Excel Converter v2.0 to try again, will you work better with Administrator privilege?

VeryPDF
-------------------------------------
Tried using Run as Administrator. Same error resulted.

Customer
-------------------------------------

Thanks for your message, you need allow Excel 2000 format in "Trust Center Settings", please look at following web pages for more information,

You receive an error message when you try to open a file type that was blocked by your registry policy settings in Excel 2010, Excel 2007 or Excel 2003,
http://support.microsoft.com/kb/922848

http://support.microsoft.com/kb/922849
http://support.microsoft.com/kb/2832600
http://office.microsoft.com/en-001/excel-help/what-is-file-block-HA010355927.aspx

VeryPDF


What is File Block?

When you try to open file types created in previous versions of Office (like a Word 95 document), the file will open in Protected View by default and the editing functions will be disabled.

File Block prevents outdated file types from opening and causes your file to open in Protected View and disables the Save and Open features. The code used to open and save the older formats have vulnerabilities that hackers can exploit. So they are security risks that should be avoided, if possible.

If the File Block settings configured by you or your administrator are set to Do not open selected file types, the file won’t open in Protected View and an error message appears. See the File Block settings explained section for more information.

The following are examples of the Message Bar for File Block. The yellow shield indicates the file can be edited, and the red shield indicates the file can’t be edited.

image

Edit a blocked file

You can make changes in the File Block area of the Trust Center that will let you open, edit, and save your blocked file.

  1. Click File > Options.
  2. Click Trust Center > Trust Center Settings > File Block Settings.
  3. Check the Open selected file types in Protected View and allow editing box.

image

View or modify File Block settings in the Trust Center

  1. Open an Office program.
  2. Click File > Options.
  3. Click Trust Center > Trust Center Settings > File Block Settings.
  4. In the File Type list, check or uncheck Open or Save for the file types you want to block or enable.

NOTE   You can’t check Open without checking Save.

File Block settings explained

  • Do not open selected file types     The file types selected with check marks are blocked from opening, or opening and saving. You will see an error message when this is set.
  • Open selected file types in Protected View     Selected file types open in Protected View. The Enable Editing button is disabled on the Message Bar and in the Backstage view.
  • Open selected file types in Protected View and allow editing Selected file types open in Protected View. The Enable Editing button is enabled on the Message Bar and in the Backstage view.

NOTE   If you work in an organization, your administrator might have set policy that doesn’t allow you to edit files that are blocked.

View my options and settings in the Trust Center

The Trust Center is where you can find security and privacy settings for Microsoft Office programs. With the consistent appearance of the ribbon in Office programs, steps to find the Trust Center are the same for each program.

  1. In an Office program, click the File tab.
  2. Click Options.
  3. Click Trust Center, and then click Trust Center Settings.

image

  1. The following list of options appears (some options may vary):
    • Trusted Publishers    Build a list of publishers of code projects you trust.
    • Trusted Locations    Designate folders on your computer in which to place files you trust from reliable sources. Files in a trusted location folder do not go through File Validation.
    • Trusted Documents    Manage how Office programs interact with active content.
    • Add-ins    Select if add-ins require digital signatures, or if add-ins are disabled.
    • ActiveX Settings    Manage security prompts for ActiveX controls in Office programs.
    • Macro Settings    Enable or disable macros in Office programs.
    • Message Bar    Show or hide the Message Bar.
    • File Block Settings    Determine if previous versions of Office program files will open.
    • Privacy Options    Make selections that determine your level of privacy with Office programs.
  2. Click the area that you want and make selections you need.

IMPORTANT   Changing Trust Center settings can greatly reduce or increase the security of your computer, its data, data on your organization's network, and other computers on that network. We advise that you consult with your system administrator, or carefully consider the risks, before making Trust Center settings changes.

By default, the following file types are blocked in Excel 2010 and Excel 2013, so you need Enable them by manual,

  • Excel 4 Workbooks
  • Excel 4 Worksheets
  • Excel 3 Worksheets
  • Excel 2 Worksheets
  • Excel 4 Macrosheets and Add-in Files
  • Excel 3 Macrosheets and Add-in Files
  • Excel 2 Macrosheets and Add-in Files

Applies to:

Access 2013, Excel 2013, Office 2013, Outlook 2013, PowerPoint 2013, Project Professional 2013, Project Standard 2013, Publisher 2013, Visio 2013, Visio Professional 2013, Word 2013, Access 2010, Excel 2010, Office 2010, Outlook 2010, PowerPoint 2010, Project 2010, Publisher 2010, Visio 2010, Word 2010

Excel 2010
  1. Click the File tab.
  2. Under Help, click Options.

    image

  3. Click Trust Center, and then click Trust Center Settings.

    image

  4. In the Trust Center, click File Block Settings.
  5. To allow the opening of a file that is blocked, click to clear the check box for that file type.

    image

  6. Click OK two times.

In addition to these steps, you can move the file to a trusted location to override the registry policy settings.

Light bulb Fix it for me

To automatically disable or enable the file restriction, click the Fix this problem link for the Disable or Enable restriction. Then, click Run in the File Download dialog box, and then follow the steps in this wizard. 

Disable Restriction:

Enable Restriction:

 

Note: These wizards may be in English only. However, the automatic fix also works for other language versions of Windows.

Note: If you are not on the computer that has the problem, you can save the automatic fix to a flash drive or to a CD. Then, you can run it on the computer that has the problem. 

Let me fix it myself

To disable or enable the file restriction yourself, follow these steps:

  1. Exit Word.
  2. Click Start, click Run, type regedit in the Open box, and then click OK.
  3. Locate and then click the following registry subkey:

    HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Word\Security\FileOpenBlock

    If the FileOpenBlock subkey does not exist, you must create it. To do this, follow these steps:

    1. Select the Security subkey.
    2. On the Edit menu, point to New, and then click Key.
    3. Type FileOpenBlock, and then press ENTER.
  4. After you select the subkey that is specified in step 3, locate the DWORD value.
    Note If this value does not exist, you must create it. To do this, follow these steps:
    1. On the Edit menu, point to New, and then click DWORD Value.
    2. Type the DWORD value for which you want to disable the restriction, and then press ENTER. For example, type FilesBeforeVersion.

    You may check the different DWORD values in the "More Information" section of this article based on the version of Word that you are running. For example, if the opening of files that were saved in earlier file formats is restricted, locate the FilesBeforeVersion DWORD value in the registry for the FileOpenBlock subkey. When you change the value of FilesBeforeVersion from 1 to 0, you can open files that were saved in earlier file formats.

  5. Right-click the DWORD value that you want, and then click Modify.
  6. In the Value data box, type 0, and then click OK.
  7. On the File menu, click Exit to exit Registry Editor.

See Also:

https://support.microsoft.com/en-us/kb/922849

https://support.microsoft.com/en-us/kb/922850

https://support.microsoft.com/en-us/kb/922848

https://support.office.com/en-in/article/What-is-File-Block-10d0e0ab-fecf-4605-befd-1e6563e7686d

VN:F [1.9.20_1166]
Rating: 10.0/10 (2 votes cast)
VN:F [1.9.20_1166]
Rating: +1 (from 1 vote)
I am getting the following error "Error: You are attempting to open a file that is blocked by your File block settings in the Trust Center.,;in line 27" with PDF to Excel Converter v2.0 and Excel 2013, 10.0 out of 10 based on 2 ratings

Related Posts

This entry was posted in PDF to Excel Converter, PDF to Excel OCR Converter and tagged , , . Bookmark the permalink.

5 Responses to I am getting the following error "Error: You are attempting to open a file that is blocked by your File block settings in the Trust Center.,;in line 27" with PDF to Excel Converter v2.0 and Excel 2013

  1. VeryPDF says:

    We have the PDF to Excel Converter version 2.0. It worked fine under Office 2010. After installing Office 2013 we get this error at the end of conversion process:

    Error: You are attempting to open a file type that is blocked by your File Block settings in the Trust Center,.; in line 213

    How can we fix this?

    Customer
    —————————————————————–
    Please look at following web page, we hoping this web page will solve this problem to you,

    http://www.verypdf.com/wordpress/201307/i-am-getting-the-following-error-error-you-are-attempting-to-open-a-file-that-is-blocked-by-your-file-block-settings-in-the-trust-center-in-line-27-with-pdf-to-excel-converter-v2-0-and-37401.html

    VeryPDF

    VN:F [1.9.20_1166]
    Rating: 0.0/5 (0 votes cast)
    VN:F [1.9.20_1166]
    Rating: 0 (from 0 votes)
  2. VeryPDF says:

    Good afternoon:

    I am using the trial version of your software to convert a scanned .pdf document to excel. I am getting the following error message and would like to know what this means.

    Error message:
    “Error: you are attempting to open a file type that is blocked by your file block settings in your Trust Center,; in line 29.”

    Not sure what this means. If you would please provide any help that you can so that I can know whether I want to purchase the product or not.

    Thanks
    Customer
    ———————————————-
    Please look at following web pages, we hope the solutions on following web pages will useful to you,

    http://www.verypdf.com/wordpress/201307/i-am-getting-the-following-error-error-you-are-attempting-to-open-a-file-that-is-blocked-by-your-file-block-settings-in-the-trust-center-in-line-27-with-pdf-to-excel-converter-v2-0-and-37401.html

    https://support.microsoft.com/en-us/kb/922849

    https://support.microsoft.com/en-us/kb/922850

    https://support.microsoft.com/en-us/kb/922848

    https://support.office.com/en-in/article/What-is-File-Block-10d0e0ab-fecf-4605-befd-1e6563e7686d

    VeryPDF

    VN:F [1.9.20_1166]
    Rating: 0.0/5 (0 votes cast)
    VN:F [1.9.20_1166]
    Rating: 0 (from 0 votes)
  3. VeryPDF says:

    How to open a file that is blocked by registry policy setting in PowerPoint 2010, 2007 or 2003?

    PowerPoint is an extremely useful tool for creating presentations. You can create high quality presentations with videos, images, sounds, formatting and many more by using it. There are some instances where you fail to open your Word document and may receive strange error messages. One of the error message that you might encounter while trying to open your Word file is “ You are trying to access a file that is blocked by registry policy settings”. Let’s discuss the cause of the above error message.

    Cause: The above error may occurs if an administrator has restricted a presentations that you are trying to open.

    Solution: There are two methods to solve the above problem:

    Method 1:
    Disable the restrictions: Disable the restriction of the file that you are trying to open. To do this follow below steps.

    For PowerPoint 2010

    * Go to File-> Help, click Options.
    * Click Trust Center-> Trust Center Settings.
    * In Trust Center Setting click File Block Settings.
    * Now unchecked the block file type.
    * Click OK and again OK.

    For PowerPoint 2007 & 2003

    * Click Start-> Run, type regedit in Run dialog box and click OK.
    * Now locate the registry subkey depending upon the PowerPoint version you are using

    For PowerPoint 2007:

    HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\PowerPoint\Security\FileOpenBlock
    For PowerPoint 2003: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\PowerPoint\Security\FileOpenBlock
    HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\PowerPoint\Security\FileOpenBlock

    * After selecting subkey, locate the DWORD value. You can check the different DWORD value based on your PowerPoint version from “More Information” section.
    * Now Right click the DWORD value that you want to change, click Modify.
    * Type ‘0’ in the Value data box and exit.

    Method 2. Move the File to a trusted location: To open blocked file, move your file to a trusted location.

    Note: In PowerPoint 2010 or 2007, it is possible to move blocked file to trusted location and override registry policy settings however in PowerPoint 2003, there is no trusted location but you can create exempt location to override the registry policy.

    Creating exempt location in PowerPoint 2003

    * Click Start-> Run, type regedit in Run dialog box and click OK.
    * Locate following subkeys:

    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common
    HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Common

    * On the Edit menu, Click New-> Key.
    * Name the key with OICEExemptions.
    * Again go to Edit-> New-> String Value.
    * Type the name of string and press enter.
    * Right click the string name and click Modify.
    * Now type the path of file and click OK.
    * Exit editor.

    VN:F [1.9.20_1166]
    Rating: 0.0/5 (0 votes cast)
    VN:F [1.9.20_1166]
    Rating: 0 (from 0 votes)
  4. VeryPDF says:

    You are attempting to open a file that is blocked by your registry policy
    setting.

    Number of error messages that will be fixed when you will apply the resolution:

    You are attempting to open a file that is blocked by your registry policy setting.

    You are attempting to open a file type <<File Type>> that has been blocked by your File Block settings in the Trust Center.

    You are attempting to open a file that was created in an earlier version of Microsoft Office. This file type is blocked from opening in this version by your registry policy setting.

    You are attempting to save a file that is blocked by your registry policy setting.

    You are attempting to save a file type <<File Type>> that has been blocked by your File Block settings in the Trust Center.

    Your error message will be anyone which are mentioned above. but don’t worry Microsoft has already published a KB for this and your issue will be resolved when you will apply the mentioned resolution.

    Resolution:
    To resolve this issue, click the following article number under the name of the Office program that you are using to view the article in the Microsoft Knowledge Base:

    Word 2010, Word 2007, or Word 2003
    http://support.microsoft.com/kb/922849

    Excel 2010, Excel 2007, or Excel 2003
    http://support.microsoft.com/kb/922848

    PowerPoint 2010, PowerPoint 2007, or PowerPoint 2003
    http://support.microsoft.com/kb/922847

    If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, thank you.
    ———————————————————–

    You receive an error message when you try to open a file type that is blocked by the registry policy settings in Visio 2013,
    https://support.microsoft.com/en-us/kb/2832600

    You receive an error message when you try to open a file type that was blocked by your registry policy settings in PowerPoint 2010 or in PowerPoint 2007 or in PowerPoint 2003,
    https://support.microsoft.com/en-us/kb/922847

    You receive an error message when you try to open a file type that was blocked by your registry policy settings in Excel 2010, Excel 2007 or Excel 2003,
    https://support.microsoft.com/en-us/kb/922848

    Error message in Office when a file is blocked by registry policy settings,
    https://support.microsoft.com/en-us/kb/922850

    Opening a file is blocked by your registry policy setting or File Block settings in Word,
    https://support.microsoft.com/en-us/kb/922849

    VN:F [1.9.20_1166]
    Rating: 0.0/5 (0 votes cast)
    VN:F [1.9.20_1166]
    Rating: 0 (from 0 votes)
  5. VeryPDF says:

    See Also:

    Error message in Office when a file is blocked by registry policy settings or File Block settings,

    http://www.verypdf.com/wordpress/201710/error-message-in-office-when-a-file-is-blocked-by-registry-policy-settings-or-file-block-settings-43596.html

    VN:F [1.9.20_1166]
    Rating: 0.0/5 (0 votes cast)
    VN:F [1.9.20_1166]
    Rating: 0 (from 0 votes)

Leave a Reply

Your email address will not be published. Required fields are marked *


Verify Code   If you cannot see the CheckCode image,please refresh the page again!