> This message is in MIME format. Since your mail reader does not
understand
this format, some or all of this message may not be legible.
--B_3299074575_330998
Content-type: text/plain;
charset="ISO-8859-1"
Content-transfer-encoding: 8bit
Hi there,
Through your feedback we have discovered an issue with refre****ng Stock
Quote queries based on referenced cells when saved in the new Excel file
format.
The issue:
If you have rows\columns of stock quotes that you reference when creating
a
stock quote and then save this as Xlsx or any new Excel file format the
stock quote data will not refresh.
Version: Excel 2008 for Mac and all subsequent updates including latest
version 12.1.1
While we are working on getting this issue resolved there are a couple of
workarounds:
1. Save your file in the Xls file format and save all newly created web
queries as Xls.
2. Create your web query but instead of referencing the cells as you did
previously you will need to enter them into the parameter value dialog:
Select the Data menu item, then select the following:
Get External Data
Run Saved Query
MSN MoneyCentral Stock Quotes and select Get Data
Click Ok at the Return External Data Microsoft Excel dialog
Type in your stock quotes followed by a comma after each quote and
click Ok
Using this method you can save as Xlsx or any Excel file format and your
query will refresh
Thanks for your understanding with this issue!
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided łAS IS˛ with no warranties, and confers no
rights.
--B_3299074575_330998
Content-type: text/html;
charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable
<HTML>
<HEAD>
<TITLE>Stock Quote Refresh Issue With Excel 2008</TITLE>
</HEAD>
<BODY>
<FONT FACE=3D"Calibri, Verdana, Helvetica, Arial"><SPAN
STYLE=3D'font-size:11pt=
'>Hi there,<BR>
<BR>
Through your feedback we have discovered an issue with refre****ng Stock
Quo=
te queries based on referenced cells when saved in the new Excel file
format=
..<BR>
<BR>
The issue:<BR>
If you have rows\columns of stock quotes that you reference when creating
a=
stock quote and then save this as Xlsx or any new Excel file format the
sto=
ck quote data will not refresh.<BR>
<BR>
Version: Excel 2008 for Mac and all subsequent updates including latest
ver=
sion 12.1.1<BR>
<BR>
While we are working on getting this issue resolved there are a couple of
w=
orkarounds:<BR>
<BR>
1. Save your file in the Xls file format and save all newly created web
que=
ries as Xls.<BR>
<BR>
2. Create your web query but instead of referencing the cells as you did
pr=
eviously you will need to enter them into the parameter value dialog:<BR>
Select the Data menu item,
=
then select the following:<BR>
Get External Data<BR>
Run Saved Query<BR>
MSN MoneyCentral Stock
Quot=
es and select Get Data<BR>
Click Ok at the Return
Exte=
rnal Data Microsoft Excel dialog<BR>
Type in your stock quotes
f=
ollowed by a comma after each quote and click Ok<BR>
Using this method you can save as Xlsx or any Excel file format and your
qu=
ery will refresh<BR>
<BR>
Thanks for your understanding with this issue!<BR>
Fergal Condron,<BR>
Macintosh Business Unit<BR>
Microsoft Corp.<BR>
This posting is provided “AS IS” with no warranties, and
confer=
s no rights.<BR>
<BR>
</SPAN></FONT>
</BODY>
</HTML>
--B_3299074575_330998--
|
