Link and Keep Source Formatting--not exact

		Microsoft Office Forums > Microsoft Excel > Excel
Link and Keep Source Formatting--not exact

FAQ

Thread Tools

Display Modes

04-09-2012, 04:19 PM

macropod

Windows 7 64bit Link and Keep Source Formatting--not exact

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,525

Hi Minny,

You'll probably get the result you're after by using Paste Special > Link to File and choosing the 'Excel Worksheet Object' or 'Picture (Enhanced Metafile)' paste format.

Gary: The OP's profile indicates Office 2010. If you want the data to be linked, you have to use 'link and keep formatting' (which may only be available in Office 2010) or the 'Paste Special' option. The 'Paste Special' option is available in Office 2007.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Paste and keep source formatting lost	moyali	Word	5	04-17-2012 03:15 PM
paste option Keep source formatting missing through remote app	mtrento	Excel	1	03-07-2012 09:44 AM
Link and change source for multiple tabs from excel to powerpoint	excel3	PowerPoint	1	01-19-2012 02:01 AM
editing source formatting	urboyfriend	Word	1	09-22-2011 02:43 AM
Keeping source formatting in Word 2003	texoz	Word	0	06-30-2009 07:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:51 AM.