Grrr hate it when software prevents me from getting stuff done
Things like this make me regret needing to keep these spreadsheets on THIS laptop with M$ Office 2010 instead of THAT laptop with Open Office ...
I have a worksheet in one .xls file (M$ Excel gives me a hard time about saving in .xls instead of its own .xlsx, but I need the backwards compatibility so everything gets saved in .xls). The sheet contains a few dozen cells of plain old text writing, no functions, no font/text games, no lookups, no numbers: it's still in what I call the "placeholder/scratchpad" mode, where I am writing down and organizing the groupings and labels that will eventually be reorganized and have numbers put next to them. This is prep work I used to do in 'vi' until I got tired of remembering and cleaning out my .txt scribbles.
I've got another .xls file with a dozen+ worksheets in it, packed with the typical spreadsheet stuff with maths and references and so on.
I try to move or copy the scribble-tab/worksheet from file #1 into file #2, and I get an error that makes no sense at all in this context:
"Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook. To move or copy the data to the destination workbook, you can select the data, and then use the Copy and Paste commands to insert it into the sheets of another workbook."
WTF? This is an entire *sheet* insertion, a standalone sheet. The number of rows and columns should not matter, it is not attempting to insert a chunk of lines into the middle of a page of stuff. This is me inserting a new paperback on my shelves and being told I can't because the chapter counts are different.
Debugging attempted: If fails for both move and copy. It fails whether I'm doing this from an .xlsx to .xls, xlsx to xlsx, and xls to xlsx - so it doesn't seem to be a version issue.
I'm going to go back to Open Office and vi and my reliable tools to get this done, but I wondered just what and why that was happening.
I have a worksheet in one .xls file (M$ Excel gives me a hard time about saving in .xls instead of its own .xlsx, but I need the backwards compatibility so everything gets saved in .xls). The sheet contains a few dozen cells of plain old text writing, no functions, no font/text games, no lookups, no numbers: it's still in what I call the "placeholder/scratchpad" mode, where I am writing down and organizing the groupings and labels that will eventually be reorganized and have numbers put next to them. This is prep work I used to do in 'vi' until I got tired of remembering and cleaning out my .txt scribbles.
I've got another .xls file with a dozen+ worksheets in it, packed with the typical spreadsheet stuff with maths and references and so on.
I try to move or copy the scribble-tab/worksheet from file #1 into file #2, and I get an error that makes no sense at all in this context:
"Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook. To move or copy the data to the destination workbook, you can select the data, and then use the Copy and Paste commands to insert it into the sheets of another workbook."
WTF? This is an entire *sheet* insertion, a standalone sheet. The number of rows and columns should not matter, it is not attempting to insert a chunk of lines into the middle of a page of stuff. This is me inserting a new paperback on my shelves and being told I can't because the chapter counts are different.
Debugging attempted: If fails for both move and copy. It fails whether I'm doing this from an .xlsx to .xls, xlsx to xlsx, and xls to xlsx - so it doesn't seem to be a version issue.
I'm going to go back to Open Office and vi and my reliable tools to get this done, but I wondered just what and why that was happening.