General

Opening Lotus Files in Excel 2007
I know this option was omitted from Excel 2007, but I am wondering if a work around has been created? Does anyone know of a way to open Lotus files in Excel 2007? Any work arounds? I recently upgraded to 2007 and lost this functionality. Thanks, Pete ... 12 Apr 2010 14:48

Track Changes without sharing
I have a spreadsheet which is a basic 'form' and will be completed and then saved under different names. So used like a template. Then the completed form could be updated by different people (but doesn't need to allow multiple editors at same time). I want to force people to enter data in certain cells, and not... 12 Apr 2010 11:26

Excel formula
I am trying to set up a spreadsheet to show the costs, after rebates, for a solar array. They rebate for New York is $1.75 per watt. That would be an easy formula of: =the number of watts*1.75, or =(C9*1000)*1.75 on my spreadsheet. However, they only reimburse a customer up to 5000 watts. what formula can I... 12 Apr 2010 19:16

Excel
How can I convert excel worksheets to ASCII file ... 12 Apr 2010 12:34

Custom Number Format
I know nothing about using custom number format, and need to undersand when and how to use it. Any link to recommend? Thanks in advance. Regards, Emece.- ... 12 Apr 2010 12:34

Date in 5 weeks from entered date
What is the formula that would allow me to enter a date in one cell (B1) and have B3 show the date 5 weeks from the date entered? ... 12 Apr 2010 11:26

.csv Re-Format Question
Hello, I copied from a source a spreadsheet that is apparently in .csv format. When I paste it into a regular Excel 2007 spreadsheet, everything is on one line; the columns don't seem to have any significance. How can I rfeformat this .csv such that all the columns (that are apparently there between the co... 12 Apr 2010 10:19

Curve fit coefficient
I know that there is a LINEST function to return the coefficient of best linear curve fit However I would like to know if there is anyway to return the coefficients of, say , a quadratic curve fit? Or if there is anyway to manual type in algorithm that excel use in polynomial curve fit? Oh and I would like to ha... 12 Apr 2010 10:19

Desparate For Help - Pivot Table Field List
Using Exccel 2003 with all current Service packs in Windows XP Pro with all current service packs. Over the weekend the pivot table field list changed sizes and I cannot extend the length of the list. When docked only about 1 inch of the list is visible. When I am able to undock the list the size is only app... 12 Apr 2010 09:13

Copying cells working only sporadically
I am having a strange phenomenon since I installed MS Office to an older Windows XP system I have. Copying cells in Excel has become ahit or miss proposition. I finally figured out that when I attempt to copy cells, for an unknown reason, a large majority of the time it now copies the cells as embedded object... 12 Apr 2010 12:34