General

Print Entire workbook problem
I've been printing multiple sheet workbooks, no problem. Then I added a new sheet, call it sheet 3. Now when I try to print "entire workbook" it prints sheets 1-2 then 4-11 then sheet 3. What's going on? If I try to print ot PDF it prints sheets 1-2, prompts to print, then sheet 3, prompts again, then 4-11, c... 23 Apr 2010 11:48

create card file from csv file
how can i create card file from a csv ... 23 Apr 2010 11:48

Deactivate a macro when used and reactivate again
I need to be able to prevent people using a macro twice in a spreadsheet untill another macro is run and then allow the first macro to be used again ... 23 Apr 2010 11:48

Multiple Sumif with concatenation
Hi All, Is it possible to use concatenation with multiple sumif? I have the following formula but it doesn't work with the concatenation, any suggestion of what I'm doing wrong Thanks in advance for any help =SUM(IF((tblProcessorActivity!$B$1:$B$2999="CG")*(tblProcessorActivity!$N$1:$N$2999=(MONTH(MAX(t... 24 Apr 2010 11:40

document doesn't auto display when selected
When I click on an existing excel document it doesn't automatically open. I have to click on something within Excel for it to display. Does anyone know what setting needs to be changed so it will open at startup? -- thx ... 23 Apr 2010 11:48

Move tab bar
Hello Is it possible to move the tab bar from the bottom of the excel sheet to the right side? I have over 20 tabs and think if they were listed vertically they could all be seen on one screen. thanks Steve ... 23 Apr 2010 15:00

All worksheets in document are not saving!
I just saved and closed an Excel document that contained about 20 worksheets. When I reopened the file, all of the worksheets, except the top one are gone!! This is about 6 hours of work gone in a heart beat. I'm using Microsoft Office Mac 2008 on a MacBook Pro, Excel version 12.2.0. Is there anyway to reco... 23 Apr 2010 10:46

Cell Formatting Defaults To Scientific
Hi I have a spreadsheet that a user is having problems with. One of the columns contains a job name which is made up of numbers and letters. If I enter 7E1, it immediately formats the cell to Scientific and turns the information into 7.00E+01 Even if I go in and format the cells to General and try to r... 23 Apr 2010 10:46

Had to repost it!!!
Query: Say i have multiple sheets dated 04/01/10 to 04/30/10, each contain names, say A, B, C, D, etc... but these name does not appear in the same order in each sheet. Now data is in time format in front of A, B, C, D, etc. Eg. in sheet 04/01/10 A1 B1 A 1:00:00 D 1:53:00 C 2:45:00 ... 23 Apr 2010 10:46

V Look Up
WHats wrong with this formaula? Cant get the thing to work =VLOOKUP(A2,Cognos!$A$3:$J$763,2,FALSE) -- Tony ... 23 Apr 2010 07:38