P
Paul Mathieu
Bad behavior with Visio Pro2007 and Excel 2007; any ideas on how can I stop it?
Pre work:
1) Create an Excel workbook with anything you want, save it.
2) Create another excel workbook with a table of data, save it (this will be
the datasource)
3) Create a Visio document, put a shape in it, link to the data in the
datasource workbook.
Reproduction Steps:
4) Navigate to the workbook created in step 1, double click to open it.
5) Start a new Excel.exe process (Start ->Run ->Excel.exe)
6) Open the datasource workbook from step 2 with the new instance excel you
just started.
7) Edit a value in the datasource workbook; DO NOT SAVE yet.
8) In Visio, refresh the data
Result: the very first Excel window opens a new "(read only)" copy of the
file you have opened in the second instance of Excel.
Expect: the data updates correctly without opening the extra doc copy just
like it does if the datasource workbook is not modified.
Pre work:
1) Create an Excel workbook with anything you want, save it.
2) Create another excel workbook with a table of data, save it (this will be
the datasource)
3) Create a Visio document, put a shape in it, link to the data in the
datasource workbook.
Reproduction Steps:
4) Navigate to the workbook created in step 1, double click to open it.
5) Start a new Excel.exe process (Start ->Run ->Excel.exe)
6) Open the datasource workbook from step 2 with the new instance excel you
just started.
7) Edit a value in the datasource workbook; DO NOT SAVE yet.
8) In Visio, refresh the data
Result: the very first Excel window opens a new "(read only)" copy of the
file you have opened in the second instance of Excel.
Expect: the data updates correctly without opening the extra doc copy just
like it does if the datasource workbook is not modified.