Paste Link - Excel 2010

Question

Good morning, MS Experts!

I'm working in Excel 2010, using Windows 7.  Two questions: 

Q1.)  Is it possible to paste/link one master worksheet to multiple worksheets in the same document while keeping all the formatting in each worksheet as the master? 

I'm creating a quarterly report using Excel 2010.  The master document has all the information that needs to be reviewed each quarter.  Last quarter I created a worksheet that linked to the Master and all formatting appears to be exact (highlighted areas, different color fonts for particular items, bolded text in certain cells, etc.) as I was asked to do. 

However, the next quarter has arrived and I need to link the master worksheet to another new worksheet.  No matter what I try, it's copying the information to the new worksheet using basic text in each cell showing a "0" in blank cells and all the formatting is gone.  Even the font style and size have changed. There are thousands of rows and 12 columns.  If I have to go line-by-line and fix it, this will be quite time consuming.  The information does link so that's a positive.  Is MS Excel limited when pasting a link in multiple locations?  Is there a workaround?  If I just copy/paste, the formatting is correct.  Something is up when I paste/link.

Q2.) Is there a way to save the worksheet I linked last quarter so no further updates are made to it?  As I said above, the links are working correctly on the updated worksheet, but it is also updating the worksheet I created last quarter.  I'm worried that won't be acceptable to my supervisor.

Again, thank you to everyone that reaches out to help me with this.  Have a wonderful day.

08-18-16 - UPDATE!   I figured out what to do.  I feel so good about this.  Anyway, for anyone else that has this problem, I'm going to give you the solution that worked for me. 

Start in the master worksheet and highlight whatever part (or all) of the worksheet you want to link, copy the material you want linked, open the blank worksheet and do a regular, old paste function.  The information copies to the new sheet.  Now while the entire worksheet is still highlighted, either go to the tool bar and choose the drop-down arrow under the Paste icon and look for the Link icon or if you are more comfortable, right click and under "Paste Option" choose the link icon (sorry I cannot show it here) or if that's not showing, choose "Paste Special" and it will be a choice under that selection.  You can check to make sure it links by making a change to your master.  But you will know it links when you see all the "0's" in your blank cells.  Those you can remove by going into File, Options, Advanced and unclicking the box that says "show a zero in cells that have a zero value" under "Display options for this worksheet."

I hope this helps.  Thank you to everyone that provided suggestions.  It means a lot to me.

Answer 1

Hello,

As per your query, you may refer to the following article and check if it helps in resolving your issue:

https://support.office.com/en-gb/article/enter-data-in-multiple-worksheets-at-the-same-time-6223d385-4c75-4dff-9881-67d17972a6c9

Please post to us if you need any further assistance and we will assist you.

Thank you.

Answer 2

Hello Sagnik:

I appreciate the suggestion and will use this in the future.  Unfortunately, I've already created the workbook and have a number of worksheets attached.  It appears as though the article will work better when I'm creating something and know how many linked sheets I'll need.  It doesn't seem to give direction now that I've already created it and have thousands of rows of information. 

Thank you, anyway.  It is a good source of material that I will keep on hand for other documents.  Have a nice day.