HT201279: Numbers '09: Exporting a spreadsheet in Excel format
Learn about Numbers '09: Exporting a spreadsheet in Excel format
-
All replies
-
Helpful answers
-
Jun 14, 2012 11:57 AM in response to patfromclioby Jerrold Green1,Pat,
The suffix identifies which table that particular Excel worksheet is representing, in this case, Table 1. If you had a Numbers sheet called Sheet 1 with a Table 1 and a Table 2, you would get two Excel worksheets; Sheet 1 Table 1 and Sheet 1 Table 2. If you don't like "Table 1", give your table a more likeable name.
Jerry
-
Jun 14, 2012 2:57 PM in response to patfromclioby Badunit,If you are exporting then importing repeatedly, it will keep appending these things to the names.
Numbers document with two sheets, both with a single table called "Table 1" will get exported as two Excel worksheets: "Sheet 1 - Table 1" and "Sheet 2 - Table 1". It creates a separate Excel worksheet for every table and names each with the sheet and table name.
Reimporting this to Numbers will result in a Numbers document with a sheet called "Sheet 1 - Table 1" and another called "Sheet 2 - Table 1" and both will contain a single table called "Table 1". It imports each Excel worksheet as a Numbers Sheet and creates a table for each called "Table 1".
It really doesn't work well to import & export repeatedly. Much better to use one app or the other.