paste link

  1. C

    "Paste Link" remains gray and not accessible

    Hello Excel world, I have a problem... I am trying to copy a table and link the table by pasting it into another workbook. But he" paste link" is gray out. What do you suggest I do to fix the problem? Please view the video below... Thanks in advance Cheers...
  2. M

    Excel Waterfall Chart cant embed in PowerPoint???

    Hello all, I'm trying to paste a Excel 2016 built-in 'waterfall' chart into PowerPoint 2016 (Paste Special > Paste Link > Microsoft Excel Chart Object) and the option to 'Paste Link' is grayed out and unavailable. Other charts work (i.e. Bar/Column/Pie) but not 'Waterfall' - does anyone know...
  3. Mister_J

    Can you Mirror/Link cells on different sheets that work both ways?

    Little bit of background: I have set up an excel chart that allows me to track projects that I'm working on and update the status as phases are completed. It is not really being used to calculate values just track data that I need to monitor and update as tasks are completed. This chart contains...
  4. D

    Excel-Macro: Paste Link to a new worksheet (Run-time error '424': Object required)

    Hey, I am currently working on a macro for duplicating a worksheet and pasting specific values from it into a new column of a remaining worksheet. However, whenever I try to paste link specific values to another worksheet, I receive the message 'Run-time error '424': Object required'. This is...
  5. C

    VBA: Open A Workbook With Constant Path But Different File Name

    Hi everyone, I'm having an issue with <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial...
  6. D

    Paste link not retaining formatting within cells

    I have a workbook which is linked to a master workbook and contains formatting within cells such as bold,italic etc but only parts of the cell are formatted. I've been trying to find out how to retain this formatting when using the paste link function but so far without any joy. I've tried...
  7. D

    Help with Macros

    Hi ! I am trying to make a dashboard for a particular excel file in which I have around 30 sheets in similar format. I need to link certain data fields on my dashboard. WHile trying to do that I created the following Macro however it only works for first 3 sheets. I want this to run for all...
  8. A

    Paste Link problem

    Hi guys, I am encountered a problem today while I am using VBA for excel. I was trying to Copy the column(8) and do paste link. Here is the code: Sub testStatus() Dim name As String Dim leftLocation As String ' initial variables Columns(8).Select...
  9. U

    Dynamic hyperlink that behaves as linked cell + linked cell

    Hi, This is my first post. I am normally a bit of a lurker. I tried for about 4 hours to work this out yesterday and few hours today on this one. I am using Excel 2010 and Windows 7 64bit. I am using an excel workbook that is updated and changed constantly, Rows are added daily, columns...
  10. N

    keeping carriage returns with paste link

    Source: cell is an address for printing on a letter. Jack's Tavern 1234 bay drive Jacksmelt city, Fl 33123 Target cell is a paste link of that address. However the paste link loses all the carriage returns making the address one continuous line. Does anyone know a solution to this problem...
  11. M

    Paste link data from CSV file Problems

    Hello, Thanks for all who will help me out from this situation. Scenario I have a "cost.csv" file that contains the cost of the toys. The cost is show in $ with two decimal places i.e. $0.75 I created a new MS Excel 2010 workbook file named as "customers.xlsx" that has four columns i.e. Item...
  12. A

    Append data from multiple worksheet to single worksheet macro

    I have a workbook with a large number of worksheets. The data in most worksheets has the same structure. For these worksheets I would like to have a macro that appends the data to a single sheet. Since the data on the worksheet have reference included I would like the data to be paste values or...
  13. A

    Linking Comments

    Hello All, I have a problem that has proven to be pretty challenging. I need to do a Paste Link and include the comments. The cell comments are lost when executing a Paste Link. I have two workbooks and I need to link several rows of data from one to the other. The comments contain valuable...
  14. A

    Paste Link with Comments Included?

    Hello All, Does anyone have any VBA code to do a PasteLink in excel and keep the comments? Whenever you do a PasteLink, it only brings over the value of the cell. It excludes the comments. I need to reference a few rows of information from another workbook but also see the comments for each...
  15. P

    Average including zero after paste link tranpose

    Dear wise excel people, I need help with an average formula that will give an accurate answer. My issue is that I need an average of what has been entered rather than for the entire selection. I have paste link transposed the data as it needs to run on Excel 2003 which can only hold 30 items in...
  16. W

    Paste Link a chart from one workbook to another within Excel

    I've created a chart in a workbook. I want to copy and paste that chart into another workbook in such a way so that when I update the original data it automatically updates both charts. I have no problem doing this between Excel and PowerPoint or Excel and Word (Copy / Paste Special / Paste...
  17. C

    Paste Link Options?

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
  18. A

    Paste Link with Absolute reference

    Hi All, I have about 43 workbooks. Each have 11 tabs. I am trying to create a new book which has a copy of tab#2 from each book. That would make 43 tabs in new book. I tried to copy those tabs in my new book using Pastelink but it does it with out absolute reference where I want to paste link...
  19. J

    Challenge: Macro to copy certain columns to another worksheet

    Hello! I need some help setting up a code that does the following: If date A* = january then paste link B*,C*,D* to worksheet 2 If date A* = februari then paste link B*,C*,D* to worksheet 3 If date A* = march then paste link B*,C*,D* to worksheet 4 Where * is any number ranging from 1 to...

Watch MrExcel Video

This Week's Hot Topics

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
Top