Showing related tags and posts accross the entire site.
-
Excel 2007 (Home Use Program Office 2007 Enterprise Edition (non commercial use only)) on Win 7 64 bit system (fully updated). AutoComplete for Cell Values stopped functioning. Since it's last use 2 weeks ago this function no longer works. I have tried every combination of switching this function...
-
I have been using Excel for quite a few years. I have just found a very strange glitch and am looking for possible explanations. I have two .cvs file created by a data loggers which measure water depths. The loggers were installed in the wells on August 12, 2010, and I created the .cvs files on August...
-
Normal 0 false false false EN-AU X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt;...
-
heres my question. I have a colume of data that is really long, in it their are some duplicate numbers. Now I used the conditional format function to change the font color of the duplicate cells red. When I use the function below to check to font color it dosnt detect that its red it just displays zero's...
-
I cannot use the error checking button in Excel 2007. It is simply gray no matter where I click in the worksheet. Can anyone help?
-
One of our users created a file using 2007, and saved as .xls. When others try opening the file, in 2007 the message is: Access Denied. Contact your administrator In 2003, the message is: Excel cannott access 'filename.xls'. The document may be read-only or encrypted. I think he was messing with...
-
I'm using Excel 2007. The program will not print to an HP Deskjet D2560. A sheet of paper goes through the printer, but it is blank. Excel prints to my Ricoh AP410 laser with no problems. Any suggestions?
-
Using Excel 2003, I sometimes get a cell (or a range of cells) into a state where a simple formula is not evaluated but displayed in the cell - e.g. =A1 I can't find a reliable way to correct this except to copy some cell that still works on top of the "bad" cell. Anyone now why this happens...
-
I have a very unusual problem. My workbook is fairly substantial and uses a good amount of vba/vb to handle UI issues as well as perform some calculations via UDFs. Recently I have found a situation where inter-sheet links stop working. The application allows the user to add cashflow engines - it does...
-
I have a couple of saved cases where Excel behaved very badly. In a very weird manner. I am a Software Engineer with over twenty years professional programming experience. Mainly embedded systems, such as medical instruments & robotics systems. Designing Operating systems and drivers. For the last...