Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Strange dual monitor problem in excel


  • Please log in to reply
4 replies to this topic

#1 3ric

3ric

  • Members
  • 34 posts
  • OFFLINE
  •  
  • Local time:01:40 AM

Posted 23 May 2012 - 03:51 PM

One of the users at my company is having an issue with dual monitors, and Excel (2010). When he drags a spreadsheet from the main monitor to his secondary monitor, the formula (in the formula bar) disappears. He can blindly edit the formula, but will not be able to see anything until he drags it back to the main monitor. For example, if he had the formula =(C1/D3) in a cell, he would be able to see the formula in the formula bar on the main monitor. Once the window is dragged onto the secondary monitor, the formula bar does not display anything. He can change cells and click back, but the formula will not show. If he clicks on another cell that has a formula, it also will not show.

Is this a case where a simple Office repair will probably fix the issue, or is this something else?

Thanks for any help!

EDIT: Sorry, this may need to be moved to Software > Business Applications. The user is running Windows 7 64 bit on a Dell 6320 with a docking station. Also, they are using 2 identical Dell monitors.


Edited by hamluis, 08 May 2014 - 04:53 PM.
Moved from Win 7 to Business Apps - Hamluis..


BC AdBot (Login to Remove)

 


#2 coxchris

coxchris

  • Members
  • 1,151 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Atwater
  • Local time:10:40 PM

Posted 23 May 2012 - 04:36 PM

Is he working on one large spreadsheet or different spreadsheets in the one monitor.

I am trying to replicate the problem with 2007 I don't see how

When you press enter excel calculates the formula you specify and the output comes out.

There is a way to show All entry formula's by CTRL+~

Microsoft Excel 2010 displays the formula details in Formula bar. In case if your excel does not show the Formula bar then you can unhide the formula bar using the View menu.

To unhide the formula bar in Excel 2010

Navigate to the View menu and then to the Show section.
Under Show section, tick the check box with label as Formula Bar.

Edited by coxchris, 23 May 2012 - 04:39 PM.

AA in Computer Networking Technology

BS in Information Technology 

Comptia A+, Project+, L+

Renewable:  N+,S+

CIW Web Design Specialist, JavaScript Specialist,  Database Design Specialist 

LPIC-1, SUSE 


#3 3ric

3ric
  • Topic Starter

  • Members
  • 34 posts
  • OFFLINE
  •  
  • Local time:01:40 AM

Posted 25 May 2012 - 04:49 PM

Is he working on one large spreadsheet or different spreadsheets in the one monitor.

I am trying to replicate the problem with 2007 I don't see how

When you press enter excel calculates the formula you specify and the output comes out.

There is a way to show All entry formula's by CTRL+~

Microsoft Excel 2010 displays the formula details in Formula bar. In case if your excel does not show the Formula bar then you can unhide the formula bar using the View menu.

To unhide the formula bar in Excel 2010

Navigate to the View menu and then to the Show section.
Under Show section, tick the check box with label as Formula Bar.


He is working on multiple spreadsheets on both monitors. I'm not certain how this can be recreated, as I've never seen it before or replicated it myself.

#4 T.Miller

T.Miller

  • Members
  • 1 posts
  • OFFLINE
  •  
  • Local time:01:40 AM

Posted 08 May 2014 - 04:38 PM

I am having a similar issue when working on multiple worksheets in a second display. The file in the second screen fails in many ways.

 

Did you get your problem fixed?

 

Thank you



#5 mgattims

mgattims

  • Members
  • 1 posts
  • OFFLINE
  •  
  • Local time:12:40 AM

Posted 16 May 2014 - 07:15 PM

I had a very similar issue yesterday helping a friend with 2007 excel. He had a dual monitor setup. The primary display was the right monitor. Data would be missing in certain dialog windows. For him he noticed it while working with charts and trying to select/edit the data sources. The problem would only occur when the excel window was in the left/secondary monitor. I changed the main display to the left monitor and the issues of missing/blank data in some dialogs went away. It seems for large negative values for window placement excel starts having issues. 

 

HKEY_CURRENT_USER\Software\Microsoft\Office\<version>.0\Excel\Options\Pos






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users