Paste Special-Paste Link problem

A

Andrew XJ

Board Regular
Joined
Feb 21, 2002
Messages
77
When i use Paste Special-Paste Links, all the blank cells in the source sheets are changes to 0 in the object cell. How to solve this problem? Please indicate.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
You will need to change your formula (link) after pasting from (for instance), =Sheet1!A1 to:

=If(isblank(Sheet1!A1),"",Sheet1!A1)
 
Upvote 0
Thanks! Dreamboat.
This works. ^_^. i should think of this. Previously i just thought of doing that in one step.
 
Upvote 0
You must log in or register to reply here.

Similar threads

PIsabel
  • Question
past without blanks
Replies
8
Views
156
Alex Blakenburg
A
F
  • Question
Excel VBA to Powerpoint - paste special chart object link
Replies
3
Views
942
Domenic
D
SunnyAlv
  • Solved
Hidden Rows VBA
Replies
9
Views
348
SunnyAlv
SunnyAlv
P
  • Question
Every time I cut or copy a tab from one sheet to another much of the formatting is lost
Replies
1
Views
401
My Aswer Is This
My Aswer Is This
K
  • Question
Excel script using if statement to copy/paste special values for specific rows
Replies
2
Views
165
kcampbell675
K

Forum statistics

Threads
1,214,606
Messages
6,120,488
Members
448,967
Latest member
visheshkotha

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top