disable user changes in pivotable

  • Thread starter Thread starter Gunnar Sandström
  • Start date Start date
G

Gunnar Sandström

Hi!
In excel 2000 i have productnumber in the row field in a pivo table.
I refresh the data from a external database.
When users change the product numbers by misstake and then refresh the data
the changed product number remains in the pivo table.
Do anyone know how to make the pivo only show the correct data from the
extenal database.
/// Gunnar
 
Hi Gunnar

If people enter incorrect data in the database (I
understand from your email thats the case), you cannot
expect a pivottable to keep the old, correct information
and only refresh the correct, new information. How should
it know whats correct and whats not?

The only thing to do, i think, is to restrict the way
people enter data into the database and make sure
incorrect values cannot be entered.

Hans
 
Hi!
The database table is read only and does not change the product numbers.
But when refreshed the pivotable shows the product number changed previously
by users in excel.
/// gunnar
 
Hi

That is very strange. Im using an pivottable linked to an
ODBC data source and it always shows the correct data.

What kind of external data source are you using? An OLAP
data source? Maybe it helps if you setup the pivottable
once again from the beginning.

Hans
 
I'm not very familiar with pivot tables, but can you lock the cells so that
users can not change tham?
 
Back
Top