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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
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
154
Alex Blakenburg
A
F
  • Question
Excel VBA to Powerpoint - paste special chart object link
Replies
3
Views
941
Domenic
D
SunnyAlv
  • Solved
Hidden Rows VBA
Replies
9
Views
346
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
400
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
164
kcampbell675
K

Forum statistics

Threads
1,214,567
Messages
6,120,268
Members
448,953
Latest member
Dutchie_1

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