Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MS Office 2003 Prof Ed SP2
Hi All,
Q 1) After working in an excel spreadsheet for a while and then out of the blue when clicked on a particular cell the system will highlight a wide range of cells and no matter what cell was clicked on the system keeps highlighting many cells. At this point not able to edit individual cells anymore and has to close down the program and the computer completely to restart it. Changed the mouse, clear temp folder, did reinstall the with Repair problem remained same. Q 2) Opening email attacjed Excel 2000 spreadsheet in Excel 2003, all remote referenced forumlas (from different worksheets) don't show up and throwing Div/0 error as if they don't exist. In every cell if manually adds the reference forumula with + the formula works but it is equivalent to reprogramming. Any ideas I appreciate. Thanks Chinna |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MS Office 2003 Prof Ed SP2
Check that you have not got a Shift key sticking on the keyboard.
-- Regards, OssieMac "Chinna122008" wrote: Hi All, Q 1) After working in an excel spreadsheet for a while and then out of the blue when clicked on a particular cell the system will highlight a wide range of cells and no matter what cell was clicked on the system keeps highlighting many cells. At this point not able to edit individual cells anymore and has to close down the program and the computer completely to restart it. Changed the mouse, clear temp folder, did reinstall the with Repair problem remained same. Q 2) Opening email attacjed Excel 2000 spreadsheet in Excel 2003, all remote referenced forumlas (from different worksheets) don't show up and throwing Div/0 error as if they don't exist. In every cell if manually adds the reference forumula with + the formula works but it is equivalent to reprogramming. Any ideas I appreciate. Thanks Chinna |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MS Office 2003 Prof Ed SP2
Problem #1 could be caused by hitting the F8 key which puts you in Extended
mode. Hit it again to toggle out of that mode. For problem #2..............are the links just to other sheets within the same workbook? You could try this trick. Select all sheets and CTRL + a(twice in 2003) to select all cells. EditReplace What: = With: = Replace all. Do you get an update of values? Gord Dibben MS Excel MVP On Tue, 9 Dec 2008 20:57:01 -0800, Chinna122008 wrote: Hi All, Q 1) After working in an excel spreadsheet for a while and then out of the blue when clicked on a particular cell the system will highlight a wide range of cells and no matter what cell was clicked on the system keeps highlighting many cells. At this point not able to edit individual cells anymore and has to close down the program and the computer completely to restart it. Changed the mouse, clear temp folder, did reinstall the with Repair problem remained same. Q 2) Opening email attacjed Excel 2000 spreadsheet in Excel 2003, all remote referenced forumlas (from different worksheets) don't show up and throwing Div/0 error as if they don't exist. In every cell if manually adds the reference forumula with + the formula works but it is equivalent to reprogramming. Any ideas I appreciate. Thanks Chinna |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MS Office 2003 Prof Ed SP2
Hi Gord, Thanks for your time. Your resolution for Prob#1 helped I was
accidentally pressing F8 key. The solution for problem#2 did not help . Alternatively if Open Office Calc is used can see all the referenced values and had save as .xls file and send it accross. Should there be any MS Office patch please help me. -Chinna "Gord Dibben" wrote: Problem #1 could be caused by hitting the F8 key which puts you in Extended mode. Hit it again to toggle out of that mode. For problem #2..............are the links just to other sheets within the same workbook? You could try this trick. Select all sheets and CTRL + a(twice in 2003) to select all cells. EditReplace What: = With: = Replace all. Do you get an update of values? Gord Dibben MS Excel MVP On Tue, 9 Dec 2008 20:57:01 -0800, Chinna122008 wrote: Hi All, Q 1) After working in an excel spreadsheet for a while and then out of the blue when clicked on a particular cell the system will highlight a wide range of cells and no matter what cell was clicked on the system keeps highlighting many cells. At this point not able to edit individual cells anymore and has to close down the program and the computer completely to restart it. Changed the mouse, clear temp folder, did reinstall the with Repair problem remained same. Q 2) Opening email attacjed Excel 2000 spreadsheet in Excel 2003, all remote referenced forumlas (from different worksheets) don't show up and throwing Div/0 error as if they don't exist. In every cell if manually adds the reference forumula with + the formula works but it is equivalent to reprogramming. Any ideas I appreciate. Thanks Chinna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
maybe i need a prof.formula for complex sump... | Excel Worksheet Functions | |||
Upgrading from Office 2003 Small Bus to Office 2003 Pro | Setting up and Configuration of Excel | |||
Office 2000/Office 2003 Excel not printing landscape vise versa | Setting up and Configuration of Excel | |||
Unable to access the Office Online Web site in Office 2003, Excel | Excel Discussion (Misc queries) |