public inbox for [email protected]
help / color / mirror / Atom feedExcel ODBC query loosing parameter when returning the query result directly to a pivot table.
3+ messages / 2 participants
[nested] [flat]
* Excel ODBC query loosing parameter when returning the query result directly to a pivot table.
@ 2021-09-08 12:34 Andreas Beier <[email protected]>
2021-09-08 15:42 ` Re: Excel ODBC query loosing parameter when returning the query result directly to a pivot table. Danny Severns <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Andreas Beier @ 2021-09-08 12:34 UTC (permalink / raw)
To: [email protected]
Hi everyone,
I am using postgres odbc for quite a while within within excel using
parameters (i.e. using ?s within the query).
When defining odbc queries in Excel I select "PivotTable Report" instead of
"Table", thus creating a pivot table directly without having the raw data
in an extra sheet.
Once created, I can alter the query and define parameter (s)linking to an
excel cell.
Everything works well until I (save and) reopen the file and try to update:
Than my excel crashs. :(
I did find out, that the parameter definition I defined before is empty
when opening the file. When I do redefine it, everthing works well again
until I (save and) reopen the file and try to update: Than my excel crashs.
:(
So it's very reproduceable.
I am using the 32bit driver, latest version and I am running Excel 2010 and
2016.
Any idea whats wrong here?
Thanks
Andreas
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Excel ODBC query loosing parameter when returning the query result directly to a pivot table.
2021-09-08 12:34 Excel ODBC query loosing parameter when returning the query result directly to a pivot table. Andreas Beier <[email protected]>
@ 2021-09-08 15:42 ` Danny Severns <[email protected]>
2021-09-09 08:46 ` Re: Excel ODBC query loosing parameter when returning the query result directly to a pivot table. Andreas Beier <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Danny Severns @ 2021-09-08 15:42 UTC (permalink / raw)
To: [email protected]
Have you tried looking at the Excel.dmp file that should have been
created by the crash. You might also want to look at the windows event
log to see if it is any help. It sounds like a data type mismatch, but
that is just a guess.
"It's so simple to be wise. Just think of something stupid to say and
then don't say it." -Sam Levenson
On 9/8/2021 7:34 AM, Andreas Beier wrote:
> Hi everyone,
>
> I am using postgres odbc for quite a while within within excel using
> parameters (i.e. using ?s within the query).
>
> When defining odbc queries in Excel I select "PivotTable Report"
> instead of "Table", thus creating a pivot table directly without
> having the raw data in an extra sheet.
>
> Once created, I can alter the query and define parameter (s)linking to
> an excel cell.
>
> Everything works well until I (save and) reopen the file and try to
> update: Than my excel crashs. :(
>
> I did find out, that the parameter definition I defined before is
> empty when opening the file. When I do redefine it, everthing works
> well again until I (save and) reopen the file and try to update: Than
> my excel crashs. :(
>
> So it's very reproduceable.
>
> I am using the 32bit driver, latest version and I am running Excel
> 2010 and 2016.
>
> Any idea whats wrong here?
>
> Thanks
> Andreas
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Excel ODBC query loosing parameter when returning the query result directly to a pivot table.
2021-09-08 12:34 Excel ODBC query loosing parameter when returning the query result directly to a pivot table. Andreas Beier <[email protected]>
2021-09-08 15:42 ` Re: Excel ODBC query loosing parameter when returning the query result directly to a pivot table. Danny Severns <[email protected]>
@ 2021-09-09 08:46 ` Andreas Beier <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Andreas Beier @ 2021-09-09 08:46 UTC (permalink / raw)
To: [email protected]
Thank you.
It is in fact a very long and well known excel problem, not specificly
connected to postgres-odbc. See:
https://stackoverflow.com/questions/44672251/excel-sql-data-query-into-pivot-table-fails-when-parame...
https://superuser.com/questions/456242/excel-pivot-table-with-external-data-source-parameter-is-not-...
https://social.technet.microsoft.com/Forums/Lync/en-US/e983efc2-ba95-4bdd-85bc-f5ce2647cbb4/cell-ref...
https://answers.microsoft.com/en-us/msoffice/forum/all/query-parameters-cell-reference-not-saved/85a...
...
Thx for your help anyway!
Andreas
Am Mi., 8. Sept. 2021 um 17:42 Uhr schrieb Danny Severns <[email protected]
>:
> Have you tried looking at the Excel.dmp file that should have been created
> by the crash. You might also want to look at the windows event log to see
> if it is any help. It sounds like a data type mismatch, but that is just a
> guess.
> "It's so simple to be wise. Just think of something stupid to say and then
> don't say it." -Sam Levenson
> On 9/8/2021 7:34 AM, Andreas Beier wrote:
>
> Hi everyone,
>
> I am using postgres odbc for quite a while within within excel using
> parameters (i.e. using ?s within the query).
>
> When defining odbc queries in Excel I select "PivotTable Report" instead
> of "Table", thus creating a pivot table directly without having the raw
> data in an extra sheet.
>
> Once created, I can alter the query and define parameter (s)linking to an
> excel cell.
>
> Everything works well until I (save and) reopen the file and try to
> update: Than my excel crashs. :(
>
> I did find out, that the parameter definition I defined before is empty
> when opening the file. When I do redefine it, everthing works well again
> until I (save and) reopen the file and try to update: Than my excel crashs.
> :(
>
> So it's very reproduceable.
>
> I am using the 32bit driver, latest version and I am running Excel 2010
> and 2016.
>
> Any idea whats wrong here?
>
> Thanks
> Andreas
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-09-09 08:46 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-09-08 12:34 Excel ODBC query loosing parameter when returning the query result directly to a pivot table. Andreas Beier <[email protected]>
2021-09-08 15:42 ` Danny Severns <[email protected]>
2021-09-09 08:46 ` Andreas Beier <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox