I am not completely sure what you want, but have you selected everything on
sheet three, and copied it.
then go to the first sheet select the entire sheet and paste special format

"Bob" wrote:

I've got a Excel document containing three worksheets. The first worksheet
gets his data from the third worksheet. It is linked and I want it to get the
same layout as the third worksheet. However, I tried everything, but I can't
find a solution. Can't find it in the offline help, neather in the online
help...

Has anyone dealed with this problem before?

Thanks in advance!