A
Aljaz
Hi!
I have this weird problem. I'm using very much pivot tables that extract
data from oracle databases but I ran into few problems, which I gather must
be application errors, since they don't happen only on my machine with the
2003 (sp1) version but is the same with excel 2000.
What I do:
I create a pivot table with a data source via odbc (oracle or microsoft,
it's the same). I either connect to a view or make a custom query in MS query.
If I have a view in oracle and then decide to add another field in that
view, then it would be adequate if I only used "select * from view". Any time
I change the view, it would change the fields in the pivot table. 2003 does
not do that (2000 on some occasions can). Instead MS Query replaces * with
all the fields in the view and makes thus a fixed query.
But that, too, wouldn't be such a problem if there was another, more acute.
In order to refresh/change the query I use Pivot Table Wizard and go back to
Edit Query. When I press this button then the mistery begins. I haven't
untill today figured out, what it is that it prevents that button from
running MS Query every time. Now it does and it does not. I press the button
and nothing happens. Now I use tricks but none of them is a constant solution
since it takes quite some repetitions of these tricks to get a possible
breakthrough:
- I refresh the data and type the logon information,
- I don't refresh the data and hope for the best,
- if both upper tricks don't work I close the file, copy paste it to another
and the open the copied file.
- if the previous trick still does not work, sometimes it helps to open a
file from a different machine.
- if it still does not work, I use all the above tricks randomly.
So far, I, luckily, could enter the existing pivot table queries, but the
idea that there will be a day when this won't be possible is the idea I
dread, especially since so much time went to formatting the fields in the
tables, the customers use.
Any ideas?
Greetings,
Aljaz
I have this weird problem. I'm using very much pivot tables that extract
data from oracle databases but I ran into few problems, which I gather must
be application errors, since they don't happen only on my machine with the
2003 (sp1) version but is the same with excel 2000.
What I do:
I create a pivot table with a data source via odbc (oracle or microsoft,
it's the same). I either connect to a view or make a custom query in MS query.
If I have a view in oracle and then decide to add another field in that
view, then it would be adequate if I only used "select * from view". Any time
I change the view, it would change the fields in the pivot table. 2003 does
not do that (2000 on some occasions can). Instead MS Query replaces * with
all the fields in the view and makes thus a fixed query.
But that, too, wouldn't be such a problem if there was another, more acute.
In order to refresh/change the query I use Pivot Table Wizard and go back to
Edit Query. When I press this button then the mistery begins. I haven't
untill today figured out, what it is that it prevents that button from
running MS Query every time. Now it does and it does not. I press the button
and nothing happens. Now I use tricks but none of them is a constant solution
since it takes quite some repetitions of these tricks to get a possible
breakthrough:
- I refresh the data and type the logon information,
- I don't refresh the data and hope for the best,
- if both upper tricks don't work I close the file, copy paste it to another
and the open the copied file.
- if the previous trick still does not work, sometimes it helps to open a
file from a different machine.
- if it still does not work, I use all the above tricks randomly.
So far, I, luckily, could enter the existing pivot table queries, but the
idea that there will be a day when this won't be possible is the idea I
dread, especially since so much time went to formatting the fields in the
tables, the customers use.
Any ideas?
Greetings,
Aljaz