Order Export Runtime Error ‘1004’

The manufacturer order forms have a limited number of rows that can be populated during export. If the order being exported is too large, with more than 100 line items, Excel may produce a Runtime Error ‘1004’. This error occurs because Excel is unable to paste beyond a specific row in the spreadsheet, due to the manufacturer locking those cells in the orders.

To work around this limitation, users can split the order export into multiple parts. For example, exporting Rooms 1-5 and Rooms 6-10 (in a 10 room design) as separate orders.

Please contact your product manufacturer if you have questions about exporting orders that do not fit into the standard Order Form.

Runtime_Error_1004