Copying a Range from another Workbook

  • Thread starter Thread starter Ruan
  • Start date Start date
R

Ruan

Hello,

Is it possible to copy a range of cells (only the values) from a closed
Workbook?

Example:
I would like to open Workbook A and have it automatically copy the range
(A8:Z1000) from Workbook B and paste (paste special - values) it to a
specific sheet in Workbook A.

I am finding that linking to another Workbook takes up to much file size,
which reduces the performance of my excel workbook.

Thanks
Ruan
 
Hi Ruan
though this can be done using macros (which would also open the second
workbook for copying the data and closing it afterwards) I would use a
cell link 8much more reliable). Also you don't have to update the links
at startup if the other workbook is closed.
Also I doubt that the file size would differ that much.
You probably have linked all cells of a sheet to your existing
workbook. Try reducing the formulas for linking (use only your range
A8:Z1000)
 
Back
Top