Currently Being ModeratedMay 5, 2012 9:55 AM (in response to Sonic10)
Ya. So that is a weird file. I was able to confirm you cannot duplicate some tables (by either copy/paste, duplicate, option/drag).
I remade the table "avg of 3" and deleted the original one. The new one I made would not duplicate either.
Currently Being ModeratedMay 5, 2012 10:03 AM (in response to Sonic10)
Your reply helps in that it means the problem is the file and not my computer or version of iWorks. Solving this problem is important for me because I routinely make 3 or 4 tables which are related to each other and create graphs from the tables. I'll have multiple sets of data so by making duplicates of the table/graph sets I can copy a new set of data into the first table of the set and everything will recalculate and regraph. It saves me a tremendous amount of time. Just have to hope someone finds the problem.
Currently Being ModeratedMay 5, 2012 12:18 PM (in response to Sonic10)
I think your document is corrupt. I tried creating a new table inside the same sheet as the other tables and could not duplicate that new table. I suggest rebuilding from scratch in a new doc.
Currently Being ModeratedMay 5, 2012 3:31 PM (in response to Wayne Contello)
The question is, why is it corrupt? This happens chronically and in new worksheets. I'll add several new tables, add data and enter functions, and copying, pasting, and duplicating suddenly quit working.
One thing I've noticed, the Normal Style (purple symbol) seems to appear in the list of styles when this happens although I haven't kept record of whether it shows up every time. I never use it and usually delete all styles except Basic and Blue Headers just so I can enlarge the playlist. The most curious thing about that is that Normal Style isn't in the list of styles shown in a new worksheet so I don't know where it comes from.
Currently Being ModeratedMay 6, 2012 4:48 AM (in response to Sonic10)
I don't use MS Office, so some of this is just speculation, but Word apparently uses Normal as the name of the default template; it wouldn't surprise me if they also used that name for the default style in Excel. Does that style show up when you copy and paste some raw data from an external source? It seems to be associated with your raw data table.
If you are importing data by copying and pasting, it might be worth trying to "clean up" that data before pasting it.
Using Paste and Match Style might be enough; I usually use one of Yvan's scripts that I keep in my Scripts menu to clean up the clipboard:
set the clipboard to (the clipboard as text)
I believe Yvan presented a more sophisticated version of that script somewhere on these boards, but the simple version has worked for me.
Currently Being ModeratedMay 6, 2012 6:57 AM (in response to Jeff Shenk)
This occurred to me last night while doing something unrelated (psychologists have a term for that). I get data from instruments as an Excel sheet. Sometimes I open the data in Excel and copy/paste from there but other times I open it with Numbers (psychologists may also have a term for this odd behavior). I suspect the Normal Style shows up when I open in Numbers. I will open in Excel from now on.
Thanks to Wayne and Jeff for your suggestions. I was really frustrated with this and it was helpful to have someone else look at it.