|
|
#1
06-02-2015, 03:26 PM
|
|||
|
|||
Pasting Only Active Excel Cells With Link
I have a Word 2013 template that I load Excel spreadsheets into using links created with the OBJECT dropdown menu. It works well except that each link loads an entire page of active and grayed-out inactive cells. The grayed-out cells contain no data, formulas, or formatting and have gray borders as opposed to the active cells whose borders are black. I've tried selecting the active cells and saving the SS while still selected and setting the active cells as the print area and saving, but no help. Is there any way of loading only the active cells? Any help greatly appreciated. 
|
|
#2
06-07-2015, 03:53 AM
|
||||
|
||||
|
Linked content necessarily includes all of what you've linked to, regardless of whether it's 'active'. Your description suggest you've linked more content than you need. If you have 'active' and 'inactive' cells interspersed, you may need you use multiple links to get just the 'active' cells.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Update Link very slow -PowerPoint Charts & object, cells etc Linked to Excel | johnseito | PowerPoint | 0 | 01-28-2014 06:24 PM |
| Pasting the attachment link of a pdf file | 747capn | Word | 0 | 01-09-2013 06:02 PM |
| borders disappear from merged cells when pasting from excel | joba | Word | 0 | 09-10-2012 11:35 AM |
| Pasting link from Excel to Publisher | agentred | Publisher | 0 | 09-03-2010 09:45 AM |
| How to insert an active page link | JudeL | Word | 0 | 10-02-2009 03:50 AM |
Pasting Only Active Excel Cells With Link
Windows 7 64bit 
Office 2013
Linear Mode
