"Update Values" Window appears after copying and pasting a cell?

J

Jack

When I copy and paste a cell that contains a formula with "VLOOKUP", a
dialog window appears titled "update values". The cell in question has
no outside references and only uses other cells within the current
workbook within its formula. Does anyone know how to stop this window
from popping up when I copy a cell like this?

This is in Excel 2007.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro that copies values from column A (from formula) to B (paste value) 1
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Stop Window from appearing after copying and pasting a cell? 0
Excel 2007 Paste Special 3
How to create absolute link to cell in another workbook (Excel 2003) 1
Paste link only - not value 4
MACRO RUN random percentage and copy of column values 1
NAME error in excel 2010 0

Top