As requested in the previous comments:
Being able to point to files on a local computer systems storage.
From the developers viewpoint -
For developing usually initially done on a stand-alone system
- web access to corporate data, or external sites at that stage being a severe security problem,
the facility could benefit from having the link being generatable in the same way as the ADDRESS function.
So that the initial development would be pointed to the local system, possibly using the file : /// addressing mode so the workbook could point to a folder on the local systems.
Then when at beta test stage, pointed to the corporate test environment.
and finally for corporate usage pointed to a stable set of corporate entries.
Remembering that regression testing will need to be pointing at a subset of the date, and then at the full set of data, but on a testing environment - so needing the location of the data changed by altering parts of the folders storage location.
I did try generating a link to a local file, but got #VALUE errors
and a link to external data that is secured (https:) gets #BLOCKED.
For me, I suspect that using the Address to generate specific file entries for a column of cells (in a table) that point to the for-each of 1 to count_of_files in a folder and extracted array of appropriate files would be very useful:
allowing the data presented to be all the actual entries where the image file has a specific pattern, and type, and the user interface could be set to optionally show just the selected entry - without needing VBA to access the server folder and to process the file entries in that.
Also - using a partition letter means that a users home (personal) storage area, or team area, or department/country/corporate set of locations could be automatically used to limit data as appropriate for data protection.