Once I split the data (my data is in a table) - initially, It appears to be fine. Then if I close and reopen the workbook my formulas are in error. Is there a quick way to correct this?
Hello,
Please try to create some sample data in a new Excel and try the operation again.
If the problem persists with the sample file, please send it to jaychivo@extendoffice.com with the detailed information of your operation.
Thanks in advance.