Forum Discussion
Excel Run time error 1004.
When I am working with SAP reports that are in Excel and I use Excel 2016 I get an error 1004. However, when I use excel 2008 it works fine. I have to prepare an excel spreadsheet showing a summary of SAP entries which is probably about 10,000 and compare it to another set of software and subtract the numbers so I can get them to match. However, Office 2016 Excel won't work but excel 2008 works fine. Could that be controls built into newer versions of Excel whereas older versions do not have the controls?
Any ideas? Thanks Ken
1 Reply
kenstaab it is error with VBA macro, take a look at:
https://docs.microsoft.com/en-us/office/troubleshoot/excel/run-time-error-1004
So probably something is wrong with add-on or extension of SAP inside excel or it is old code which is not working well with newer version of Excel.
If possible try disable add-on and see if it works?
If not, you need to check with SAP support team.
