web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / I am not able to impor...
Microsoft Dynamics GP (Archived)

I am not able to import the forecast spreadsheet. A macros message pops up when opening the spreadsheet asking to disable, enable, or view only. Can you please tell me how can I disable this macros message from popup. Is it related to the macros Setting? C

(0) ShareShare
ReportReport
Posted on by RaghavSharma 410

I am not able to import the forecast spreadsheet. A macros message pops up when opening the spreadsheet asking to disable, enable, or view only. Can you please tell me how can I disable this macros message from popup. Is it related to the macros Setting? Cause our Macro security level is set to medium and not allowing me to change it to Low.

*This post is locked for comments

I have the same question (0)
  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: I am not able to import the forecast spreadsheet. A macros message pops up when opening the spreadsheet asking to disable, enable, or view only. Can you please tell me how can I disable this macros message from popup. Is it related to the macros Settin

    Are talking about Sales Forecasting which is part of the Mfg modules?   If so, you must use the Import Utility to import.  In that case, it requires a tab (preferred) or comma delimited file.    I think I saw an ISV that also has an import tool, but don't remember who it was from.  

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

  • RaghavSharma Profile Picture
    RaghavSharma 410 on at
    Re: I am not able to import the forecast spreadsheet. A macros message pops up when opening the spreadsheet asking to disable, enable, or view only. Can you please tell me how can I disable this macros message from popup. Is it related to the macros Settin

    Hi Dan,

    thanks for your reply, the problem here is that i am not able to open  the spreadsheet a macro message pops up that ask me only to disable, enable or view only. Please help me out with this.

  • Verified answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    Re: I am not able to import the forecast spreadsheet. A macros message pops up when opening the spreadsheet asking to disable, enable, or view only. Can you please tell me how can I disable this macros message from popup. Is it related to the macros Settin

    Hi Rhaghav,

    You mention an macro message pop-up... is that in Excel ? if so, all the Excel version from 2007 and up are not by default disabling the macros that are embedded in an Excel workbook. Before that you could just set the security threashold to 'low' when using macro-enabled workbooks. By now, you have to have the folders  where the workbooks are stored to the 'Trusted Locations' entries in Excel. See your Help in Excel about how to manage this. This will allow you to circumvent the opening warnings and enable the macros right away. Don't be fooled, even when there are no VBA code in Excel workbooks, the warning may appear just because you have external linked data in the Sheets.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans