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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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.