LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default using 'paste link' into seperate tab

I have a parent spreadsheet in tab 1 and on seperate tabs I have chunks of
the information through paste special and paste link. When the parent cell
is empty, the paste link command is putting a zero in instead of leaving it
blank. This is messing up my averages. I have tried changing the category
in format cells but this has no effect.

I anyone knows the answer it'd be much appreciated :)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. tln Links and Linking in Excel 0 April 22nd 07 04:28 PM
Can I link spreadsheets in two SEPERATE instances of excel? aequanimitas Setting up and Configuration of Excel 2 August 22nd 06 09:16 AM
How do I link info from 2 seperate documents at same time. tafferjim New Users to Excel 2 October 13th 05 12:31 PM
How to link cells in seperate spreadsheets without the $ Cesar_us Excel Worksheet Functions 0 June 22nd 05 08:58 PM
Paste Link enters a 0 into the cell where I paste. How do I elemin UNR Excel Discussion (Misc queries) 4 March 28th 05 01:54 AM


All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"