excel paste link issue

Microsoft Office 2003 basic edition
December 11, 2009 at 05:51:47
Specs: Windows XP
I use Excel 2003 for data collection. In one workbook I have 7 worksheet. 5 sheets have total columns which I link to a summary sheet (so 5 weeks worth of data is displayed on one sheet) then those totals are linked to the last sheet to give %s for the month. It has been working fine until recently. The pasted links show up in the cell but the information from the original sheet is not being carried over. I had a similar problem with formulas being in the cell but not calulating and discovered the program switches to manual from automatic on it's own - is it something similar with the pasted link? How do I make them work again without retyping them? Like I said they are there just not working.

See More: excel paste link issue

Report •

December 11, 2009 at 07:20:34

Please post one of the linked formulas that doesn't work. Copy the formula from the formula bar and the cell contents from the cell itself.


Report •

December 11, 2009 at 17:13:02
The formula is fine. The cell of original sheet has data. I hit copy, go to page number two -right click, paste special, paste link - and the data should show up. It worked fine for quite a while and now suddenly doesn't. When I click on the cell the pasted link is still there in the cell but the data does not carry over from the original page.

I'm not sure what you're suggesting - the fomular is fine and the point of using the link is to not have to copy every cell (there are about 34 of them x 60 clients every month)

What am I not understanding about your suggestion?

Report •

December 12, 2009 at 06:36:45

I was asking for more information to help come up with a solution.

What you say you are doing should work.

As it isn't working I wanted to see exactly what was in one of the cells with a link.

When you say the data does not carry over from the original page, what does the cell show. Is there an error message, is it blank, do you just see the link formula???

Please copy the formula from the formula bar for one of these cells and paste it into your reply and then copy the cell itself and paste that into your reply as well.


Report •

Related Solutions

December 14, 2009 at 05:03:22
5 sheets titled Name, Name 1 ect to Name 5 - I copy paste special, paste link, the links show up and look like this =Name!$AC$13 ='Name (5)'!$AC$13 (etc) these are two actual links that I copied from the formula bar as you suggested - there are 171 actual links on the summary page for a months worth of data comming over from the 5 seperate sheets.

on the original page the data from that cell is a number 0 - 100 - the next digit I'm showing you is a copy from the cell on the summary page as you requested - 0 - it should be a 5 the links are there they are just not working and the funny thing is they use to - they just stoped working -

there is no error message, no green triangle showing a problem or inconsistancy - they are there - just not working.

Like I said a similar thing happened with formulas on a different workbook - I have discovered that after using formulas a dozen times or so the program switches the caluation to 'manual' from automatic - if you go under tools you can switch it back and they work fine - in that case also the formulas are always there they just don't work until you go under the calulation tools and switch it back to auto - I'm thinking something similar is going on here but I can't figure out how to 'turn it back on'

Report •

December 14, 2009 at 06:24:43

Do you have 5 sheets titled Name, Name 1 ect to Name 5 or are they

Name, Name (1)  to Name (5).

Does anything happen if you click the f9 function key?


Report •

December 14, 2009 at 12:54:26
They are Name, Name (1) etc - f9 has no effect

Report •

December 14, 2009 at 13:12:35

Have you taken this workbook and loaded it onto someone else's PC, to see if the problem is with Excel that you are running.

Also does this link problem occur if you start a completely new workbook, and do a paste special - Link between cells in the new workbook, (not a copy of the existing one).

These two tests may help narrow down the problem area.

I did wonder if an Excel Repair Install would be worth trying, but it's probably best to test the workbook on someone else's PC first.


Report •

December 15, 2009 at 05:32:56
same problem on 3 different machines - I created this workbook as a templet for multiple users for 60+ clients (1workbook ea) on 7 different machines. The first workbook that stopped working belongs to client A, and is on PC L/S - PC L/S has 12 of these workbooks 11 of the 12 are working so far -

I copied Client A's workbook and put on my machine - same issue- the machine makes no difference. One thing I noticed yesterday trying to figure this out is that the $ symbol from some of the cells has disappeared the really funny thing is that if i type it back in, it still doesn't work - I have to recopy and paste the link to make it function. To make it even stranger some of the cells have carried over the data even witout it and others with it have not -

I can get it to work only if I recopy the orginal cell and go through the process again - I just don't want to have to go through all this work every dozen uses when/if it stops - that's a huge chunck of time - the orignal templet works fine - again very similar to the auto/manual problem from before.

I know that all the pages are protected so the staff are not messing with it -

why would the $ symbol suddenly disappear? and why would some links without it work properly while others with it and without it not work at all?

Report •

December 15, 2009 at 07:34:36

The $ signs in formulas are not necessary for a link or reference to work. =Sheet2!A1, works the same as =Sheet2!$A$1 or =Sheet2!$A1. The difference is that when dragging the formula, the row or column preceded by a $ sign doesn't change.

That aside, I can't explain why $ signs would disappear from formulas or why they stop working.

From the tests with other machines, the problem is not with the Excel program, so a repair install is not going to work.

At this point I have no other suggestions.


Report •

December 15, 2009 at 17:08:44
I'm jumping in late here, but the only thing that comes to mind is a corrupt worksheet.

I have seen cases where everything is fine up until a specific cell is copied or referenced. After that things fall apart.

In some cases I've been able to locate the specific cell by breaking the worksheet into "smaller" worksheets by saving small sections as files. Once I find the file that doesn't work, I can narrow it down farther and farther until I locate the offending cell.

This won't work in every case since breaking up worksheets and workbooks can cause formulae to fail, etc. but there have been cases where I've been able to find the corruption in this manner.

Good luck!

Report •

December 18, 2009 at 04:43:48
Thanks for trying to help - both of you! Still no fix yet I'll post if I find the magic bullet

Report •

Ask Question