TheBig1980s
IS-IT--Management
- Jun 11, 2007
- 60
The client has a dual monitor. And, we have a 3rd-party Excel Add-In that "pushes" data into our accounting system from this excel spreadsheet with a click of a button in the Add-Ins tab.
On one monitor, we see the Excel spreadsheet containing this data that we "push" with this Add-In. When we successfully push, the other monitor automatically opens a read-only version of this same spreadsheet.
We need to find a way for Excel to not produce this read-only spreadsheet on the second monitor. You see, as we continue testing, the client is updating the “first” spreadsheet with changes and saving. But, on the subsequent “pushes”, our accounting system is pulling from the read-only sheet and is not updating with changes being made on the first spreadsheet.
We have contacted the 3rd party about this, but they have not responded. I'm hoping that someone out here on the newsgroups has a quick fix, regardless of any experience with this Add-In.
Please help!
On one monitor, we see the Excel spreadsheet containing this data that we "push" with this Add-In. When we successfully push, the other monitor automatically opens a read-only version of this same spreadsheet.
We need to find a way for Excel to not produce this read-only spreadsheet on the second monitor. You see, as we continue testing, the client is updating the “first” spreadsheet with changes and saving. But, on the subsequent “pushes”, our accounting system is pulling from the read-only sheet and is not updating with changes being made on the first spreadsheet.
We have contacted the 3rd party about this, but they have not responded. I'm hoping that someone out here on the newsgroups has a quick fix, regardless of any experience with this Add-In.
Please help!