Software

Ask something
Discussion Locked

Excel file problem

0 helpful
3 replies

by evileyejoe

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there a problem with copying protected worksheets from one file to a new excel file? I have a user that has created a very large file and has copied a lot of data that was protected. I have had a user do this before and I had the user go back and unprotect and the data that she wanted to copy. I then had her create a new file and then copy the data and it worked.

Is this something that has to be done before copying? Does anyone know?

3 replies

by mous

the data in the worksheet should be unprotected before it is copied. you could have them protect the worksheet and specify that no cells could be copied. then they would have to unprotect first.

This discussion is closed to new replies.