General
in [Excel]
|
Error created when try to Print Preview or Print When try to print or print preview system is generating an error: "Print titles must be contiguous and complete rows or columns." Used excel for years ever seen this error before. Using Excel 2007 on Vista, we just upgraded to SP2 for both systems. After testing a few times, I notice that system is generating... 1 Jun 2010 17:32
MATCH returning #N/A I'm having MATCH returning #N/A for some items in the list and not for others. I can't figure out why. Here's the formula: =IF($E26="","",INDEX(F$49:F$125,MATCH($E26,ECMOMLIst,0))) ECOMLIst has a list of items to choose from in cell E26. I want to be able to populate the cell the formula is in with the c... 1 Jun 2010 17:32
save a file on a CD. I want to save a file on a CD. When I try, I'm told it is not a legal operation ( or something to that effect) and that I must get permission from the 'Administrator". Who would that be?? ... 1 Jun 2010 17:32
Excel 2007 format cells to date format Hi got a problem with excel. everytime I open a file the cells are formated in a date format and I have to reformat them. Any suggestions to solve that thanks -- Stefan ... 1 Jun 2010 16:26
Information for Pivot Table I have a column with the following information: F2=1/3/2010 F3=1/15/2010 F4=2/14/2010 and so on I'm creating a Pivot Table to display this information and right now it shows each week. I really want to the Pivot Table to show the data based on the month. How do i take the information above (e.g. 1/3/2010... 1 Jun 2010 17:32
Template on Server 2008 I've put an Excel template (.xlt)(Excel 2003 sp3) in a public folder on a server that is running server 2008. I put shortcuts to it on several windows machines and some open it as a worksheet adding a 1 to the end of the name, as it normally would as a local file, but some machines open it as a template. Wind... 2 Jun 2010 17:37
Check data range and return false value if a cell is blank Example Check row A1:R1 and if at least one cell is empty then S1 should indicate "incomplete" otherwise "complete" if every cell in the row has a value ... 1 Jun 2010 16:26
Scales on Charts. I created a chart but the scale on the Y axis increments by .5 (1 to 1.5 to 2 to 2.5 to 3 to 3.5) How can I change it to increment by whole numbers, 1, 2, 3, 4, ,5, etc.... ... 1 Jun 2010 15:19
Active Workbook Using Excel 2007, I have a macro where I use a workbook, then save as a new named workbook. I want to keep the original workbook open. What code language will accomplish this? Even manually, I do not see how to save as a copy and keep original file open. Thank you ... 1 Jun 2010 18:39
IF Statement or VLOOKUP I don't know if I should use an IF statement or VLOOKUP but but i would like to do the following: IF A2=0073 THEN B2 = Sales IF A3 = 0083 THEN B3 = District Column A will contain information like: 0082, 0092, 0073, etc. Column B is empty right now but i want to use a formula to insert the ID name based on th... 1 Jun 2010 14:12 |