A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel Add-In and Dual Monitor Causing Read-Only



 
 
Thread Tools Display Modes
  #1  
Old June 3rd, 2010, 07:32 PM posted to microsoft.public.excel.misc
childofthe1980s
external usenet poster
 
Posts: 23
Default 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  
Old June 3rd, 2010, 08:49 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.