ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 vs previous versions (https://www.excelbanter.com/excel-discussion-misc-queries/189283-excel-2007-vs-previous-versions.html)

Nic

Excel 2007 vs previous versions
 

Since excel 2007 has over a million rows, if I have data on rows that the
previous versions of excel does not have and I send the spreadsheet to
someone with an older version, will they be able to make changes to the data
on the rows that the previous version doesn't have? For example, if I have
data on row 70000, will someone with a previous version of excel be able to
make changes on that row or even see that row?

Ron Rosenfeld

Excel 2007 vs previous versions
 
On Thu, 29 May 2008 09:57:01 -0700, Nic wrote:


Since excel 2007 has over a million rows, if I have data on rows that the
previous versions of excel does not have and I send the spreadsheet to
someone with an older version, will they be able to make changes to the data
on the rows that the previous version doesn't have? For example, if I have
data on row 70000, will someone with a previous version of excel be able to
make changes on that row or even see that row?


No. And they probably won't even be able to open the file.

You will have to convert your file into a compatible version -- and tools for
doing that exist in Excel 2007,
--ron


All times are GMT +1. The time now is 05:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com