I don't understand why not...

[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

 

[Paul Corrado]

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

 

[Graham Yetton]

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

 

[an]

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
.