MIME-Version: 1.0
From: Andreas Beier <anbeier@gmail.com>
Date: Wed, 8 Sep 2021 14:34:28 +0200
Message-ID: 
 <CADKKJw-jc6YCQkqmFrsDye2_qOe6QuP1XoC5f=CxYi_y77dhEQ@mail.gmail.com>
Subject: Excel ODBC query loosing parameter when returning the query result
 directly to a pivot table.
To: pgsql-odbc@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001fd07b05cb7b1bf4"
Archived-At: 
 <https://www.postgresql.org/message-id/CADKKJw-jc6YCQkqmFrsDye2_qOe6QuP1XoC5f%3DCxYi_y77dhEQ%40mail.gmail.com>
Precedence: bulk

--0000000000001fd07b05cb7b1bf4
Content-Type: text/plain; charset="UTF-8"

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

--0000000000001fd07b05cb7b1bf4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi everyone,</div><div><br></div><div>I am using post=
gres odbc for quite a while within within excel using parameters (i.e. usin=
g ?s within the query).</div><div></div><div><br></div><div>When defining o=
dbc queries in Excel I select &quot;PivotTable Report&quot; instead of &quo=
t;Table&quot;, thus creating a pivot table directly without having the raw =
data in an extra sheet. <br></div><div><br></div><div>Once created, I can a=
lter the query and define parameter (s)linking to an excel cell. <br></div>=
<div><br></div><div>Everything works well until I (save and) reopen the fil=
e and try to update: Than my excel crashs. :(<br></div><div><br></div><div>=
I did find out, that the parameter definition I defined before is empty whe=
n 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. :(

</div><div><br></div><div>So it&#39;s very reproduceable.<br></div><div><br=
></div><div>I am using the 32bit driver, latest version and I am running Ex=
cel 2010 and 2016.</div><div><br></div><div>Any idea whats wrong here?</div=
><div><br></div><div>Thanks</div><div>Andreas<br></div><br></div>

--0000000000001fd07b05cb7b1bf4--