If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Add-In and Dual Monitor Causing Read-Only
Hello:
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! childofthe1980s |
#2
|
|||
|
|||
Excel Add-In and Dual Monitor Causing Read-Only
It sure sounds like choices are limited.
I would continue to contact the 3rd party to ask for help. That 3rd party may even want you to buy updates, but you could just tell them if they don't support the currect product (assuming it's not too old), then you'll take your business elsewhere. Since you can't get at the "guts" of that addin, I think your only paths will be to train the user to ignore that second monitor (or maybe minimize or open another workbook that covers/hide that irritating window). (Or simply ask the user to turn off the monitor???) childofthe1980s wrote: Hello: 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! childofthe1980s -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|