Can you mail merge information from protected Excel sheet?


B

bjf144

I have a protected spreadsheet that is 95% locked. The 5% that is not locked
consists of user input fields and the remainder of the spreadsheet calculates
answers. I want to mail merge the answers from the formulas onto labels, but
these are the locked fields. The locked fields are not available when I
select the Excel spreadsheet fields. Is there a way to get the data from a
protected spreadsheet?
 
Ad

Advertisements

Y

YESHWANT JOSHI

try this one and hope this will solve your problem

select the entire source worksheet, press ctrl+c
open new worksheet, press alt+e+s+v
save the new file and try to get the data getting this file as source

click yes if this works
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top