SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Edit locked cells in a protected sheet in Excel?

Reply
New User
Posts: 1

Edit locked cells in a protected sheet in Excel?

Hi all,

I tried using proc export to edit a protected worksheet in an existing Excel document. I was able to replace data in unlocked cells, but not in locked cells. Is it possible to give SAS the sheet's password so it can write to locked cells? If so how would I do this?

[This is the code I used:

proc export data = new

     outfile = "&folder/&file"

     dbms = excel replace;

     sheet = "Main";

run;
]

Ask a Question
Discussion stats
  • 0 replies
  • 465 views
  • 0 likes
  • 1 in conversation