troubleshooting Question

Excel 2010 issue with the paste link function

Avatar of timprussell
timprussell asked on
Microsoft OfficeMicrosoft Applications
5 Comments1 Solution286 ViewsLast Modified:
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?
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros