Vertices refresh

Sep 14, 2014 at 1:04 PM
NodeXL,

Please tell me how to refresh the Vertices spreadsheet to reflect any changes in the Edges spreadsheet.

I had a few spelling errors in my Edges spreadsheet (e.g. John Johnston instead of John Johnson). I corrected all the spelling errors in the Edges spreadsheet, but the Vertices spreadsheet still has a vertex for each of my previous mispellings (i.e. there is still a John Johnston vertex).

Unfortunately, correcting the spelling in the Vertices spreadsheet still resulted in that previous mispelled vertex (e.g. John Johnston) being isolated from the connections with the correctly spelled vertex (e.g. John Johnson).

Thanks.

-Curt
Coordinator
Sep 15, 2014 at 5:19 AM
Hello!

Thank you for the interest in NodeXL!

NodeXL repopulates the Vertices worksheet whenever the Show Graph or Refresh Graph command is performed.

Vertices are also written based on data found in the Edges worksheet when the NodeXL>Data>Prepare Data>Get Vertices from Edges Worksheet command is performed.

You may want to clear the contents of the Vertices worksheet first, or run an Excel>Data>Remove Duplicates command.

Regards,

Marc