How to make a drop down list in excel 2010 update#
But after I clicked it and selected the correct file (it's a circular reference, so it is the current file), it simply did nothing and did not update the If not, check the Queries & Connections button to see if it lists anything. This problem is not limited to any particular Excel version.
I tried deleting the name referenced in the local connection but that did nothing because it wasn't being referenced anywhere that I could see. The Edit Links command is unavailable if your workbook doesn't contain links. The problem there is that I can't see the "SharePoint List" option in my The default is the system name (serial number) or RCHASE12. Most often a PivotTable is created using the data in the same workbook.Thanks, I'm still not being successful.This one is just like linking with a picture choice like BMP. Cells with good file links will be skipped.
How to make a drop down list in excel 2010 full#
Make sure the path type is set to full path. Dear all, I have a link in my excel (visible in data/edit links) but I cannot find in which cell this link exists.
The data link cannot be created because excel cannot be found