EXCEL EXPORT

[Woop122]

PROC EXPORT

DATA=ODDSRATIOS_COMBINED

DBMS=XLSX 

OUTFILE = "FILE PATH"

REPLACE;

SHEET = 'ODDS RATIOS';

RUN;

I keep getting an error that says cannot replace sheet because it has existing formulas that reference other pages

ERROR: export unsuccessful. 

I know there's a hot fix available but I can't download it because of the server I'm working on. Is there any way around this problem? 

I need to be able to update the exported excel file w/ different iterations without deleting the sheet and re-creating the formulas each time. 

[Yavuz]

as i understand "odds ratios" sheet has been already created in excel. firstly change your code and Replace sheet name as "my_data". Then get figures from "my_data" sheet to "odds ratios" sheet in excel by creating cell link.

[Reeza]

Try creating a named range and then exporting to the named range.