I have an Excel file that's folder was connected to the Catalog.
In that folder I had a file with 4 sheets. I added the 4th sheet to the map via the catalog pane.
By default, it became a standalone table, let's call this Table A.
This table did not have OIDs so I ran the table to table function, to create a copy of Table A with OIDs, and to change some of the field types from text to doubles (lat/longs in Excel file were text, so I needed them to be doubles to import XY data). Let's call this Table B.
I right-clicked Table B in the Contents Pane, and chose Display XY Data
I created a new layer with all the data points, let's call this Layer B.
I saved the file continuously throughout and worked on it for a few hours after.
Later on, I removed Table A, as it was not needed anymore.
I saved and closed the program.
I just came into work, and when I opened the map, no points from Layer B were displayed on the map - I opened the attribute table and it was empty.
I opened Table B, and it was also empty.
Is there any reason for this?
