ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   When I double click an Excel file in Explorer, it does not load. (https://www.excelbanter.com/excel-discussion-misc-queries/53639-when-i-double-click-excel-file-explorer-does-not-load.html)

jlamirande

When I double click an Excel file in Explorer, it does not load.
 
When I double click an Excel file in Explorer, it does not boot up. Rather,
Excel starts but does not load even a blank spreadsheet. It is likely a set
up parameter but I can't find it.

I also would like to know if there is a way to alter text in other adjacent
cells when a single cell is changed. For example, when a date goes past
current I would like to change the other cells in the row to red. Or if a
check box is selected indicating a task is complete, I want to strike through
the other cells in the row. Any help would be appreciated.

Dave Peterson

When I double click an Excel file in Explorer, it does not load.
 
Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

jlamirande wrote:

When I double click an Excel file in Explorer, it does not boot up. Rather,
Excel starts but does not load even a blank spreadsheet. It is likely a set
up parameter but I can't find it.

I also would like to know if there is a way to alter text in other adjacent
cells when a single cell is changed. For example, when a date goes past
current I would like to change the other cells in the row to red. Or if a
check box is selected indicating a task is complete, I want to strike through
the other cells in the row. Any help would be appreciated.


--

Dave Peterson

Mladen_Dj

When I double click an Excel file in Explorer, it does not load.
 
For your secon question:

Use Conditional formating. Select range you want to format based on some
condition(s), and go to Format-Conditional Formating, and there set
condition for your data. Search Excel help for more about Conditional
Formating, and how to use it.

"jlamirande" wrote in message
...

I also would like to know if there is a way to alter text in other
adjacent
cells when a single cell is changed. For example, when a date goes past
current I would like to change the other cells in the row to red. Or if a
check box is selected indicating a task is complete, I want to strike
through
the other cells in the row. Any help would be appreciated.




navychef

When I double click an Excel file in Explorer, it does not load.
 

YES!!! Unchecking the box works! Thanks, this was driving me up the
wall! :)


--
navychef
------------------------------------------------------------------------
navychef's Profile: http://www.excelforum.com/member.php...o&userid=29457
View this thread: http://www.excelforum.com/showthread...hreadid=482065



All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com