Forum Discussion

geoteach337's avatar
geoteach337
Copper Contributor
Sep 06, 2021

Excel behaving as if it were two tables

I have created an Excel document from two other Excel documents, but they will not sort across the 'invisible boundary.' They are the same width, and have the same fields but they sort in two groups....
excel
Excel on Mac
geoteach337's avatar
geoteach337
Copper Contributor
Sep 07, 2021
I did an aggressive component copy and paste into a new document and it seemed to have cleared any kind of weird, bogus Microsoft code that had infected this file. I wish it was properly coded.
mathetes's avatar
mathetes
Silver Contributor
Sep 07, 2021

geoteach337 wrote: I did an aggressive component copy and paste into a new document and it seemed to have cleared any kind of weird, bogus Microsoft code that had infected this file. I wish it was properly coded.

 

I'm not even sure what you mean by some of what you've written. What, for example, I "an aggressive component copy and paste"? 

 

Anyway, it's also not clear if you're still seeking help. If so, can you post a copy of the material in question?

  • geoteach337's avatar
    geoteach337
    Copper Contributor
    Sep 08, 2021

    Hi. A copy and paste of the whole file into another Excel file did not correct the error, so I broke it up into parts, the header, some sectionalised into columns, and some sectionalised into rows, to get the errant code to reset, and it seems now to behave in a compliant way. That's what aggressive cutting and pasting means! Thanks for your help. Problem, for now, solved. Best, Andrew

    mathetes 

Resources