Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 sheet containing look ups won't open in Excel 2007
I recently had Office 2007 on my work PC. Others are still on 2003. All
spreadsheets created so far are on 2003 and I recently changed one of them to include look up functions from lists and, it has dates and formulas to calculate network days etc. Opening this in 2007 causes 2007 to crash continually and recover the file - all formatting is lost. Any ideas on how to solve this? Also - every time I open excel in 2007 it says it's in compatible mode - what does that mean exactly? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 sheet containing look ups won't open in Excel 2007
By any chance are you looking up the ENTIRE column?
-- Don Guillett Microsoft MVP Excel SalesAid Software "daftchickhanley" wrote in message ... I recently had Office 2007 on my work PC. Others are still on 2003. All spreadsheets created so far are on 2003 and I recently changed one of them to include look up functions from lists and, it has dates and formulas to calculate network days etc. Opening this in 2007 causes 2007 to crash continually and recover the file - all formatting is lost. Any ideas on how to solve this? Also - every time I open excel in 2007 it says it's in compatible mode - what does that mean exactly? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 sheet containing look ups won't open in Excel 2007
The look up function appears in each cell in a particular column, yes.
The weird thing is that I can open the same spreadsheet that we used in 2008 and all the formatting is OK - but, there were no lookups on that sheet. If there is no patch for it, what would be the best way to recreate the spreadsheet with the look ups in it so that it can be looked at by users of 2003 and 2007? If i recreate it in 2007 will the functionality be seen in 2003? "Don Guillett" wrote: By any chance are you looking up the ENTIRE column? -- Don Guillett Microsoft MVP Excel SalesAid Software "daftchickhanley" wrote in message ... I recently had Office 2007 on my work PC. Others are still on 2003. All spreadsheets created so far are on 2003 and I recently changed one of them to include look up functions from lists and, it has dates and formulas to calculate network days etc. Opening this in 2007 causes 2007 to crash continually and recover the file - all formatting is lost. Any ideas on how to solve this? Also - every time I open excel in 2007 it says it's in compatible mode - what does that mean exactly? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make XLS files open in Excel 2003 instead of Excel 2007? | Setting up and Configuration of Excel | |||
Excel 2007 cannot open Excel 2003 documents. Registry Policy Setti | Setting up and Configuration of Excel | |||
How to open Excel 2003 / 2007 password protected file in Excel 200 | Excel Discussion (Misc queries) | |||
Excel 2007 compatability mode, can't open when saved by excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2007 xlsx files open as Read-Only in Excel 2003 after Compat | Excel Discussion (Misc queries) |