Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Problem w/OCX

Hi,

I have an Excel file that was created using MS Excel 2003 that uses a
number of VBA functions to reformat a graph based on a choice the user
makes from a drop down list. It runs fine on multiple computers, but I
have a computer (Windows XP SP2/Office 2003) which happens to be in a
conference room that the drop down list just shows up looking like a
broken link with an outlined box. I've tried -

uninstall/reinstall Office 2003 Pro and updates from Office Update
Reinstall latest versions of MSXML 2.6, 3.0, 4.0
Ran the System File Checker (SFC)
Ran Microsoft Update to verify all Critical and Recommended Updates
installed

I'm assuming that I need to reregister an ocx file. But, which one?

Any suggestions?

Thanks.

John
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Problem w/OCX

After much troubleshooting, the problem has been resolved. I was looking
in completely the wrong direction. In testing further, we found that if
we used Remote Desktop to access the PC and open the Excel file, it
worked! The problem was eventually traced to a ~1-1/2 yr old ATI video
driver. In the conference room, this PC is connected to an LCD projector
via a DVI (digital) connection. Due to the fan failing on the current
video card, I purchased another ATI card and had the same problem. But,
I found that it worked if I used the standard VGA (analog) connection. I
downloaded and installed the current version of the drivers and the
problem was gone.

John

John wrote:
Hi,

I have an Excel file that was created using MS Excel 2003 that uses a
number of VBA functions to reformat a graph based on a choice the user
makes from a drop down list. It runs fine on multiple computers, but I
have a computer (Windows XP SP2/Office 2003) which happens to be in a
conference room that the drop down list just shows up looking like a
broken link with an outlined box. I've tried -

uninstall/reinstall Office 2003 Pro and updates from Office Update
Reinstall latest versions of MSXML 2.6, 3.0, 4.0
Ran the System File Checker (SFC)
Ran Microsoft Update to verify all Critical and Recommended Updates
installed

I'm assuming that I need to reregister an ocx file. But, which one?

Any suggestions?

Thanks.

John

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Colon at the end of excel file name(ex: problem.xls:1, problem.xls financeguy New Users to Excel 2 January 15th 10 01:15 AM
Started out as an Access problem. Now an Excel problem RobertM Excel Discussion (Misc queries) 2 April 26th 06 07:30 PM
problem with a conditional max problem Brian Cornejo Excel Discussion (Misc queries) 1 February 18th 05 06:25 PM
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? OCI Excel Programming 0 May 16th 04 10:40 PM


All times are GMT +1. The time now is 05:43 AM.

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

About Us

"It's about Microsoft Excel"