topic Re: proc export issue in ODS and Base Reporting

proc export issue

gyambqt — Thu, 14 Apr 2016 03:15:41 GMT

Hi Experts,

I am getting error message:

Can not replace sheet because it has existing formulas that reference other pages

when I export the data into an Excel file.

I understand the reason why it has generated the error but would like to know if there is a work around?

Thanks

Reeza — Thu, 14 Apr 2016 03:29:33 GMT

Can you explain further?

How are you exporting your data? To a pre-populated excel workbook?

If you have formula's can you use ods tagsets and put the formula's back in?

Have you dropped the information first?

gyambqt — Thu, 14 Apr 2016 05:11:26 GMT

thanks problem solved!!!!!!