| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I reduce size of XL 2007 file to save as XL 97 ?
I have a 45KB excel 2007 file which I need to save in an earlier version of
excel. Whenever I try to do this, I get a warning that there will be significant loss of functionality and data will be lost. Any ideas, please? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I reduce size of XL 2007 file to save as XL 97 ?
"deltawiskey" wrote in message
... I have a 45KB excel 2007 file which I need to save in an earlier version of excel. Whenever I try to do this, I get a warning that there will be significant loss of functionality and data will be lost. Any ideas, please? If you have used functions that are only available in Excel 2007, then those are the things that will be lost - if you have only used functions that are available in Excel 97, then ignore the warning... |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I reduce size of XL 2007 file to save as XL 97 ?
Since Excel also warns for loss of data, there are probably cells to the right of column IV or below row 65536
These warnings will not occur if they don't apply to the workbook in question. -- Kind regards, Niek Otten Microsoft MVP - Excel "Gordon" wrote in message ... | "deltawiskey" wrote in message | ... | I have a 45KB excel 2007 file which I need to save in an earlier version of | excel. | | Whenever I try to do this, I get a warning that there will be significant | loss of functionality and data will be lost. Any ideas, please? | | | If you have used functions that are only available in Excel 2007, then those | are the things that will be lost - if you have only used functions that are | available in Excel 97, then ignore the warning... | |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I reduce size of XL 2007 file to save as XL 97 ?
"Niek Otten" wrote in message
... Since Excel also warns for loss of data, there are probably cells to the right of column IV or below row 65536 In a file only 45KB big? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I reduce size of XL 2007 file to save as XL 97 ?
<In a file only 45KB big?
easily -- Kind regards, Niek Otten Microsoft MVP - Excel "Gordon" wrote in message ... | "Niek Otten" wrote in message | ... | Since Excel also warns for loss of data, there are probably cells to the | right of column IV or below row 65536 | | | | In a file only 45KB big? | |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I reduce size of XL 2007 file to save as XL 97 ?
I don't have xl2007, but am wondering if some of the formulas might be
sumproducts of entire columns, which xl2003 does not support... -- John C "Niek Otten" wrote: <In a file only 45KB big? easily -- Kind regards, Niek Otten Microsoft MVP - Excel "Gordon" wrote in message ... | "Niek Otten" wrote in message | ... | Since Excel also warns for loss of data, there are probably cells to the | right of column IV or below row 65536 | | | | In a file only 45KB big? | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to reduce file size when converting to pdf for excel 2007? | Excel Discussion (Misc queries) | |||
| Excel 2002; how to reduce the size of the save dialogue window? | Excel Discussion (Misc queries) | |||
| how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
| reduce the size of a file | Excel Discussion (Misc queries) | |||
| How reduce the file size of Excel 2007 files (wasted non value spa | Excel Discussion (Misc queries) | |||
Hybrid Mode
