nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Multiple layers within a single spreadsheet

Mark_

Within a single spreadsheet, I am attempting to create/add a second layer using data on a second sheet. When I select the cells on the second sheet in the 'Add layer' dialogue, I receive an error saying "Data already belongs to a hosted ArcGIS layer". Is this simply not possible or am I missing something?

To clarify:

Sheet 1 data → layer 1 created; works fine

Sheet 2 data x unable to create layer 2

Find more posts tagged with

Accepted answers

ShannonCardoza

Good afternoon @Mark_,

Thank you for posting your inquiry. Another user had reported similar behavior, can you check the workflow in this post https://community.esri.com/t5/arcgis-for-excel-questions/cannot-add-the-worksheet-to-arcgis-for-excel-after/m-p/1517329#M222?

For Sheet 2 are you trying to add the same Excel data from Sheet 1? Or are these two entirely different datasets on the sheets?

Thank you!

-SC

All comments

MarkYoung2721

Hi,

I have the same error but I have deleted the hosted feature layer on Portal (11.3) so not sure why its still giving me the error Data already belongs to a hosted ArcGIS layer.

Thanks

Mark

ShannonCardoza

One more mention @Mark_ if you delete the shared layer, you will be able to re-add the data again.

ShannonCardoza

Thanks @Mark_ the current workaround still applies - copy the data, then paste it to another sheet using "Paste with Values".

Mark_

Two different datasets on the sheets.

ShannonCardoza

Good afternoon @Mark_,

For Sheet 2 are you trying to add the same Excel data from Sheet 1? Or are these two entirely different datasets on the sheets?

Thank you!

-SC

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.