Excel/SharePoint formulas not working

[ohowson]

I have a SP list, and have exported it to Excel, saved the little file, opened in Excel, set it to auto-update etc etc. Now I need to perform a VLookup on some other data that I've put in to sheet 2, and combine info from sheet 1 as well. All this combined info needs to go into Sheet 3, "Results". Sheet 1 is called "Y8 Unit 1 Tracking". So However, in Results if I type in ='Y8 Unit 1 Tracking'!A2 it shows the formula, as if the show formulas was unchecked. However, other formulas are calculating fine. Anyone have any idea what may be going on?

Thanks

[alina]

=IF([End Date]=''" , "TBC",IF[End Date]< (Today -14), "Archived" , IF([End Date]

This formulae for a calculated field in a SharePoint list is not working. End date is a column and Today I think it the function for todays date in sharepoint.

[saron]

Excel 2003 relied heavily on auto-format when formatting data whereas Excel 2007 is rather more sophisticated. There are now style galleries for tables, cells and pivot tables which provide the user with more choice and variety of predefined templates as well as the facility for customising styles. Auto-format can still be used but it needs to be added to the Quick Access Toolbar.

The insert row command from 2003 has disappeared; now you just have to press TAB to insert rows of data or alternatively cut and paste.

One of the major changes is the new referencing structure which creates a defined name at the same time as the table is created. This means that names created manually in Excel 2003 workbooks may not be recognised by this new structure and may therefore need renaming.

Two-way synchronisation between Excel and SharePoint has also bitten the dust. After the data has been exported to SharePoint changes made on SharePoint will emerge on Excel but not the other way around. The new SharePoint data will overwrite what is in Excel when Excel is refreshed.

The vastly increased workbook size in Excel 2007 can also cause some problems since full row and column references created in Excel 2003 now relate to many more rows and columns than the original workbook will have intended. Similarly, names used in formulas in Excel 2003 may prove incompatible with formulas in Excel 2007 as they may conflict with the newly expanded list of cell references. In many cases Excel 2007 will alert the user to this potential hazard and automatically prefix incompatible names with an underscore ( __ ). However, external references do have to be changed manually.

Users of Excel 2003 may balk at the changes made to their beloved program but in many cases theses are things that can be rectified. Where they cannot be it is generally because the new method of doing things is more focused and efficient. Nonetheless it is well worth enrolling on a course to teach you more about these changes and how to adapt to them as it would be a real shame to miss out on all the benefits that Microsoft Excel 2007 has to offer.