I don't understand why not...

  • Thread starter Thread starter an
  • Start date Start date
A

an

Hello!
Sincerly, I don't understand. Why not?

I have a book with link to database in SQL. In Sheet1!A1
start the original data.
Sheet2: I did Copy/Paste Special/Values.
Sheet3: Exactly, to other data work.
When I refresh the Book the data change only in sheet1 and
not in Sheet2. Why? Who is possible "blocked" data in
Sheet1 (after Copy/Paste Special/Values) to make others
calculs?
Thanks in advance.
an
 
Not sure if I follow you exactly, but if you copied formulas from sheet 1
and then used Paste/Special/Values to add them to sheet 2, you would only
have copied the formula results (the values that appear) and not the
formulae. Thus the data in sheet 2 are constants, not formulae and will not
refresh..

HTH

PC
 
You pasted the values! This does not create any link
betwwen the cells.
If you want sheet2 to equal sheet1 then you need to put
formulae in sheet2 - in sheet2 A1 =sheet1!(A1) etc.
Graham Yetton
 
Ok!
Exactly...
Many Thanks.
an
-----Original Message-----
You pasted the values! This does not create any link
betwwen the cells.
If you want sheet2 to equal sheet1 then you need to put
formulae in sheet2 - in sheet2 A1 =sheet1!(A1) etc.
Graham Yetton
.
Click to expand...
 
Back
Top