This has worked for me before, not sure if it will work for you.
If you need to preserve the original links, save the file with a different name. Then go to Edit, Links and change the source to itself.
Worth a try.
You are not going to be able to transfer everything at one go. But, to transfer Page Setup values, this is what you need to do. Open the original worksheet. Go to file Page setup. Click OK. Go to the worksheet copy, Press CTRL/y.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.