This user's frustration is a symptom of a much bigger problem, not a minor workflow quirk. When you have to right-click, browse, and select a file for every single row in a table, the tool has stopped working for you. You are doing the data management, not the spreadsheet. That distinction matters because it reveals why traditional spreadsheets are no longer fit for modern, file-heavy workflows.
Let's be direct about what's happening here. The user is linking hundreds of PDFs from a single folder, names are similar, and the only sorting option is alphabetical. That is a recipe for errors, not productivity. The suggestion to drag and drop a file directly into a cell is not a luxury; it's a baseline expectation for any tool that claims to handle structured data. Right now, the user is forced to behave like a file clerk, manually matching names to cells, when the computer should be doing the matching. The fact that the dialog box refuses to sort by most recent file is the final insult, it shows the software has no awareness that the user's workflow is sequential, not alphabetical.
This is where the conversation needs to shift. Instead of asking how to work around these limitations, users should ask why the spreadsheet doesn't understand the relationship between the table and the folder. An AI-native spreadsheet would recognize that when you add a row, you likely need to attach the most recently created PDF. It could surface a live preview of the folder, sorted by date, and let you confirm with a single click. Better yet, it could let you drag a file from your desktop into a cell and automatically create the hyperlink, populate the file name, and even extract metadata from the PDF. That is not a futuristic dream; it is a logical next step for a product that treats data as something to be connected, not just typed.
The practical takeaway is this: if you are spending minutes per row on file linking, you are not the problem. The spreadsheet is. Stop accepting the right-click-and-browse ritual as the only way. Demand a tool that lets you drag, drop, and walk away. The user who posted this question is not asking for a minor convenience; they are asking for a fundamental redesign of how files and cells interact. That redesign is overdue, and it is exactly what an AI-native spreadsheet should deliver.