Paste Link Limits in Excel

[June1975]

Does anyone know of any limits when using the paste link function in Excel?

Im trying to consolidate a series of worksheets into one workbook but when I use the paste link function in Excel the number of rows taken over does not exceed around 60 rows
and tnot the full number of rows say for example 147......

Is there a limit on the number of rows taken across or do you have to paste link in chunks?

 

[GlennUK]

It used to be 6553 elements ( cells ). Does that seem to be the limit you are hitting?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[June1975]

No its more like around 900 elements.......
Basically where the page breaks in the destination workbook it cutoffs the data

 

[GlennUK]

I have no trouble doing it. Please tell us all the exact steps you are taking when you try to do this.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[June1975]

Select cells A1:J140
Copy
Open up another instance of Excel
select cells(1,1)
Edit--> paste special
Paste Link

........and at this point I only get the following range from the source range. A56:J56 in the new work book and not all the data.

 

[combo]

Do not use two excel instances, they communicate using excel.8 format, without extended options. For instance cell contents is truncated to 256 characters. Available paste formats are different too.

combo

 

[June1975]

But how can you link the data if you don't have 2 instances of Excel? I use the paste link fucntion so that I can update the data in one area only....

 

[GlennUK]

Excel is designed to have multiple workbooks open at the same time. You navigate from one to the other by using the Window menu command. That's how you Paste Link workbooks together.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.