| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems Down saving from Excel 2007
I wrote a spreadsheet in Excel 2007 but now someone using 2000 wants to use
it. When I get a "Significant loss of functionality" error. But the error talks about overlapping conditional formatting. So I thought this wouldnt be a problem. However when I open the spreadsheet in 2000 a lot of the cells are showing the "#NAME?" error. When I open the spreadsheet in compatibility mode in 2007 the spread sheet runs okay. I am really struggling to find the problem How anyone got any suggestions. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems Down saving from Excel 2007
What do you have in those cells giving the #NAME error? Perhaps you
are making use of formulae from the Analysis Tool-Pak add-in (which is built-in in 2007, but which needs to be explicitly installed in earlier versions). Hope this helps. Pete On Aug 4, 11:11*am, VoxBox-Richard wrote: I wrote a spreadsheet in Excel 2007 but now someone using 2000 wants to use it. *When I get a "Significant loss of functionality" error. *But the error talks about overlapping conditional formatting. *So I thought this wouldn’t be a problem. However when I open the spreadsheet in 2000 a lot of the cells are showing the "#NAME?" error. When I open the spreadsheet in compatibility mode in 2007 the spread sheet runs okay. *I am really struggling to find the problem How anyone got any suggestions. Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems Down saving from Excel 2007
I don't think I am using the analysis tool-pak functions. There dosen't seem
to be a common error to the fomulae I am using. I got rid of some of the errors by unhiding a sheet. But this has far from solved the problem Any more suggestions? Thank you. "Pete_UK" wrote: What do you have in those cells giving the #NAME error? Perhaps you are making use of formulae from the Analysis Tool-Pak add-in (which is built-in in 2007, but which needs to be explicitly installed in earlier versions). Hope this helps. Pete On Aug 4, 11:11 am, VoxBox-Richard wrote: I wrote a spreadsheet in Excel 2007 but now someone using 2000 wants to use it. When I get a "Significant loss of functionality" error. But the error talks about overlapping conditional formatting. So I thought this wouldnt be a problem. However when I open the spreadsheet in 2000 a lot of the cells are showing the "#NAME?" error. When I open the spreadsheet in compatibility mode in 2007 the spread sheet runs okay. I am really struggling to find the problem How anyone got any suggestions. Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems Down saving from Excel 2007
Actuly I have just found that IMABS formula is causin the problem is this
from the analysis tool-pak? "VoxBox-Richard" wrote: I don't think I am using the analysis tool-pak functions. There dosen't seem to be a common error to the fomulae I am using. I got rid of some of the errors by unhiding a sheet. But this has far from solved the problem Any more suggestions? Thank you. "Pete_UK" wrote: What do you have in those cells giving the #NAME error? Perhaps you are making use of formulae from the Analysis Tool-Pak add-in (which is built-in in 2007, but which needs to be explicitly installed in earlier versions). Hope this helps. Pete On Aug 4, 11:11 am, VoxBox-Richard wrote: I wrote a spreadsheet in Excel 2007 but now someone using 2000 wants to use it. When I get a "Significant loss of functionality" error. But the error talks about overlapping conditional formatting. So I thought this wouldnt be a problem. However when I open the spreadsheet in 2000 a lot of the cells are showing the "#NAME?" error. When I open the spreadsheet in compatibility mode in 2007 the spread sheet runs okay. I am really struggling to find the problem How anyone got any suggestions. Thank you. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems Down saving from Excel 2007
Yes it is - and any of the complex number functions. If you install
the ATP in XL2000 it might be that those #NAME errors disappear. Hope this helps. Pete On Aug 4, 12:40*pm, VoxBox-Richard wrote: Actuly I have just found that IMABS formula is causin the problem is this from the analysis tool-pak? "VoxBox-Richard" wrote: I don't think I am using the analysis tool-pak functions. *There dosen't seem to be a common error to the fomulae I am using. *I got rid of some of the errors by unhiding a sheet. *But this has far from solved the problem Any more suggestions? Thank you. * "Pete_UK" wrote: What do you have in those cells giving the #NAME error? Perhaps you are making use of formulae from the Analysis Tool-Pak add-in (which is built-in in 2007, but which needs to be explicitly installed in earlier versions). Hope this helps. Pete On Aug 4, 11:11 am, VoxBox-Richard wrote: I wrote a spreadsheet in Excel 2007 but now someone using 2000 wants to use it. *When I get a "Significant loss of functionality" error. *But the error talks about overlapping conditional formatting. *So I thought this wouldn’t be a problem. However when I open the spreadsheet in 2000 a lot of the cells are showing the "#NAME?" error. When I open the spreadsheet in compatibility mode in 2007 the spread sheet runs okay. *I am really struggling to find the problem How anyone got any suggestions. Thank you.- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems Down saving from Excel 2007
The IMABS function is covered by the Excel help facility (as is every other
Excel function but one). That will tell you whether or not it is part of the Analysis ToolPak, and it will also tell you plenty of other useful information. -- David Biddulph "VoxBox-Richard" wrote in message ... Actuly I have just found that IMABS formula is causin the problem is this from the analysis tool-pak? "VoxBox-Richard" wrote: I don't think I am using the analysis tool-pak functions. There dosen't seem to be a common error to the fomulae I am using. I got rid of some of the errors by unhiding a sheet. But this has far from solved the problem Any more suggestions? Thank you. "Pete_UK" wrote: What do you have in those cells giving the #NAME error? Perhaps you are making use of formulae from the Analysis Tool-Pak add-in (which is built-in in 2007, but which needs to be explicitly installed in earlier versions). Hope this helps. Pete On Aug 4, 11:11 am, VoxBox-Richard wrote: I wrote a spreadsheet in Excel 2007 but now someone using 2000 wants to use it. When I get a "Significant loss of functionality" error. But the error talks about overlapping conditional formatting. So I thought this wouldn't be a problem. However when I open the spreadsheet in 2000 a lot of the cells are showing the "#NAME?" error. When I open the spreadsheet in compatibility mode in 2007 the spread sheet runs okay. I am really struggling to find the problem How anyone got any suggestions. Thank you. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems Down saving from Excel 2007
Thank you very much! All sorted.
Richard. "Pete_UK" wrote: Yes it is - and any of the complex number functions. If you install the ATP in XL2000 it might be that those #NAME errors disappear. Hope this helps. Pete On Aug 4, 12:40 pm, VoxBox-Richard wrote: Actuly I have just found that IMABS formula is causin the problem is this from the analysis tool-pak? "VoxBox-Richard" wrote: I don't think I am using the analysis tool-pak functions. There dosen't seem to be a common error to the fomulae I am using. I got rid of some of the errors by unhiding a sheet. But this has far from solved the problem Any more suggestions? Thank you. "Pete_UK" wrote: What do you have in those cells giving the #NAME error? Perhaps you are making use of formulae from the Analysis Tool-Pak add-in (which is built-in in 2007, but which needs to be explicitly installed in earlier versions). Hope this helps. Pete On Aug 4, 11:11 am, VoxBox-Richard wrote: I wrote a spreadsheet in Excel 2007 but now someone using 2000 wants to use it. When I get a "Significant loss of functionality" error. But the error talks about overlapping conditional formatting. So I thought this wouldnt be a problem. However when I open the spreadsheet in 2000 a lot of the cells are showing the "#NAME?" error. When I open the spreadsheet in compatibility mode in 2007 the spread sheet runs okay. I am really struggling to find the problem How anyone got any suggestions. Thank you.- Hide quoted text - - Show quoted text - |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems Down saving from Excel 2007
You're welcome, Richard - thanks for feeding back.
Pete On Aug 4, 1:32*pm, VoxBox-Richard wrote: Thank you very much! *All sorted. Richard. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with saving a Excel file | Excel Discussion (Misc queries) | |||
| Two problems with Excel 2007 | Excel Discussion (Misc queries) | |||
| Saving to Sharepoint in Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel Viewer causes problems saving shared spreadsheet | Excel Discussion (Misc queries) | |||
| Excel 2007 Problems | Excel Discussion (Misc queries) | |||
Linear Mode
