proc export issue

[gyambqt]

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 · Accepted solution]

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]

thanks problem solved!!!!!!