On Jan 30, 6:07*pm, c1802362 wrote:
On Jan 30, 6:55*pm, Tim Williams wrote: For #2:
What are the formats of the source/destination workbooks?
Are you running in compatability mode?

Tim

On Jan 30, 3:43*pm, c1802362 wrote:

The formats of the source and destination sheets are identical.
However, I'll try pasting the data from the downloaded file in as
values on a new sheet and see if that solves the problem. I'm not sure
what compatibility mode is. Can you elaborate?

Art

This link outlines what Compatability Mode is:
http://technet.microsoft.com/en-us/l...ffice.12).aspx

Tim