A user has a problem with the "paste link" function in Excel 2010. He has a column about 1450 rows deep in several work books and he is trying to use paste link to link them to a new workbook in a new file. When he does this below the relivant data it fills in 0's to the max rows, 1048xxx rows! I tried to recreate this on another system and it didn't do this. We have tried both clicking at the top of the column and just selecting the rows of the column when selecting what to copy.
Office was reloaded onthe machine and a office removal script was run but it seems what ever in the profile has caused this is still there. Is there a way to limit a workbook/file to fewer rows to create less of a problem?