Copy from workbook to workbook

BKG SPORTS

Board Regular
Joined
Jul 16, 2010
Messages
136
When I copy a list with formula's to another workbook, the columns
come up zero's. How to make this work?
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
10,846
Office Version
  1. 2019
Platform
  1. Windows
Thats because you don't have the source of the formula in the new workbook.

If you just need the results in the new workbook, not the formula use pastespecial values instead, this does mean that changes made in the original workbook afterwards will not be reflected in the copy.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,084
Messages
5,526,755
Members
409,717
Latest member
Oscarsalone

This Week's Hot Topics

Top