DATA Step, Macro, Functions and more

EXCEL EXPORT

Reply
Occasional Contributor
Posts: 17

EXCEL EXPORT

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. 

Contributor
Posts: 54

Re: EXCEL EXPORT

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.
Super User
Posts: 19,878

Re: EXCEL EXPORT

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

Ask a Question
Discussion stats
  • 2 replies
  • 152 views
  • 0 likes
  • 3 in conversation