Our Brands

Welcome to the Schneider Electric Website

Welcome to our website.
		
How can we help you today?
How Do I Configure Microsoft Excel To Allow Macros To Run when running reports using Repgen?

Issue
The ION Enterprise 5/6 or PME 7/8 reporter application fails to generate a report with the following error: "Your Excel security settings do not allow this waveform processing to run."




Product Line
StruxureWare Power Monitoring Expert, Reporter

Environment
ION Enterprise 5/6, Power Monitoring Expert 7/8, Microsoft Excel 2007/2010/2013/2016

Cause
The Microsoft Excel security settings are not setup to allow trust access to the VBA project object model.

Resolution

A number of the default Reporter Excel-based reports require Trust Access to the VBA project model. Follow the steps below to change this setting within Microsoft Excel 2016. Other Microsoft Excel versions will have a similar procedure.

1. Run Micrsoft Excel.
2. Click on the 'File' tab located in the upper left corner of the window.
3. At the bottom of the pop-up menu, clidk on Options.
3. Click on the 'Trust Center' tab.
4. Click on 'Trust Center Settings'.
5. Click on 'Macro Settings'
6. Place a check-mark in the 'Trust access to VBA project model' check box within the 'Developer Macro Settings' section.
7. Rerun the report.

** Ensure that Macros are enabled within MS Excel.

Schneider Electric Ireland

Users group

Discuss this topic with experts

Visit our community and get advice from experts and peers on this topic and more

Need help?

  • Where to buy?

    Easily find the nearest Schneider Electric distributor in your location.

  • Search FAQs

    Search topic-related frequently asked questions to find answers you need.

  • Contact Sales

    Start your sales enquiry online and an expert will connect with you.

  • All Support & Contact

    Find answers now. Search for a solution on your own, or connect with one of our experts.

I'd like to receive news and commercial info from Schneider Electric and its affiliates via electronic communication means such as email, and I agree to the collection of information on the opening and clicks on these emails (using invisible pixels in the images), to measure performance of our communications and improve them. For more details, please read our Privacy Policy.

  • Products Documentation
  • Software Downloads
  • Product Selector
  • Product Substitution and Replacement
  • Help and Contact Centre
  • Find our Offices
  • Where to buy
  • Careers
  • Company Profile
  • Report a misconduct
  • Accessibility
  • Newsroom
  • Investors
  • EcoStruxure
  • Job Search
  • Blog
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.