I also always get Run-time error '1004' when I click Run Forecast button. I should have the latest version (downloaded two weeks before). I'm working with Excel 2007, German version.
When you use a VBA code to select a range that is not in the active worksheet, VBA will show you the run-time error 1004. Because, if you want to select a cell or range of cells for a particular worksheet needs to be active at that point. You cannot select a cell from sheet1 if sheet2 is active right now.
Troubleshooting StepsStart Microsoft ExcelOn the Menu Bar select "File" > "[Excel] Options" > "Trust Center" > "Trust Center Settings..." > "Macro Settings"In the top section, select the radio button for "Disable all macros with notification"In the bottom section, check the box for "Trust access to VBA project object model"Click "OK" and "OK" to save the settingsClose ExcelWhen generating a new ADI spreadsheet, Excel will ask if the Macros should be allowed to run. Allow the macros to run. Only enable macros from trusted sources. Regards,Rachel Gomez
Thank you for alerting this. I just tried it with Excel 2007 and German regional settings. The regression ran fine with the example input data.
If you have changed the input data, you can send you template through as an attachment by replying to the notification email of this post, and we will investigate to resolve the issue.
