Numbers - Reset to Default Colour Palette

I am curious what you did differently from me that resulted in the palette changing in the new document. Here is what I did and the palette stayed as the same default Numbers palette:

1. Created an Excel file. I used the "wood" theme so the colors would be obviously different.
2. Imported it into Numbers. The palette in Numbers is the "wood" colors in this document.
3. Put some data in the table. Used some color fills from the palette in the table.
4. Created a new Numbers document. The color palette is the standard one Numbers uses.
5. Deleted the default table just to get it out of the way.
6. Went to the imported document and copied the table
7. Went to the new document and Pasted.

At the end, the fills already in the table remained the same colors but the standard Numbers palette remains for new fills or to overwrite the fills that were already used.

That is interesting. A recent question was asked about how to change the colors in the palette. No one knew. And now here is your post with different palettes. Apparently it can be done but darned if I know how.

I see that the theme used in Excel carries over to the palette in Numbers when the file is imported but I do not know how to change it once it is set.

If your document is all on one sheet, you can Select All, Copy, then Paste into a new Numbers document.

If your document is multiple sheets and no formulas or charts on a sheet reference cells on other sheets, you can repeat that process for the other sheets.

If your document is multiple sheets with formulas that reference other sheets, if you can move everything to one sheet you can do the same copy/paste as mentioned above.

If your documents are all basically the same except for the data, you could duplicate one of the good ones then copy/paste the data from the oddball one into the duplicate to recreate it.

Apple uses a proprietary iwa format for files internal to a Numbers document so it is not possible to read them or modify them (as far as I know). I tried replacing with the style file with one from another Numbers document but all it does is corrupt the document.

Badunit

you copied the table, instead of the sheet.

That will make the difference.

Paul.

Must be something else. I followed the same steps as above but copy/pasted the sheet to the new document and it had no effect on the color palette. The palette remained correct.