Shared Workbook opens as read-only I have a shared workbook which seems to work fine sometimes (multiple users can edit at the same time) but other times when I try to open it I get a message saying "file is locked for editing. Open as Read-Only". Why is this happening? How do I fix it? Thanks ... 30 Mar 2010 16:09 Linking Formula I have a workbook with multiple data sheets. Each data sheet has a sum total in cell B4. I created a summary sheet to pull all the totals into it. I entered the following linking formula: ='(1)'!\$B\$4, now I want to drag this formula down and have it automatically change to the next sheet. For example ='(2)'!\$B... 30 Mar 2010 16:09 Brugervenlig udfyldning I en faktura ønsker jeg at man ved at taste ENTER automatisk kan gå til forudbestemte celler der skal indtastes. Eksempel hvis adresssefeltet starter i B5-B6 ogB7 så skal man derefter med ENTER komme til F14, ved ENTER til A16 o.s.v. blot for at give et eksempel. Er der nogen der har en idé? ... 30 Mar 2010 15:01 If formula with dates Hello: I need a formula that can look at column "A" and calculate the number of days from today --- could be either before today or in the future and if it is equaled to or less than 90 return "Y" otherwise "N".... I keep getting "VALUE!" errors. Please help. Thank you. Monika ... 30 Mar 2010 16:09 If Statement Nesting? Can You Nest an If Statment so that the Logic has to check 2 different cells before it outputs the True/False date? ... 30 Mar 2010 18:25 Count the number of columns on row that are not empty within a Micky: Thanks, but that does the same thing as my code, what I need is for the last cloumn with data in it within the range A3: AD97. Any ideas on that? "מיכאל (מיקי) אבידן" wrote: This might help: LR = ActiveSheet.UsedRange.Rows.Count LC = ActiveSheet.UsedRange.Columns.Count and so, Cells(L... 30 Mar 2010 15:01 Is Error Help on a formula Hello, I need a little help changing this formula: =IF(ISNUMBER(A2),A2,DATEVALUE(LEFT(A2,10))) to return a blank if the referencing cell is blank. I appreciate the help. jim ... 30 Mar 2010 15:01 Excel 2010 Beta Professional Will not "save" or "Save As". Response is that "Excel has encountered a problem and must close". Returns to working spread sheet . Further efforts to save reults in same problem. Have no problem saving in any other program in the Professional Suite. Have uninstalled, reinstalled and repaired twice. No change. --- f... 30 Mar 2010 15:01 AutoComplete feature - Turn off In certain files I work with the annoying feature above reacts and enters a string of text as soon as I enter the first letter. I notice the ON/OFF button is under Tools, Options (xl2003) and Office Button Options (xl2007). These GLOBAL settings have always confused me as - I would like for this to apply on a... 30 Mar 2010 15:01 Export to Word and keep formatting I have fields in my excel document that include double spacing, etc. When I export to Word, I loose that formatting. Can I fix this? Thanks! ... 31 Mar 2010 11:00