Forum Discussion
files saving as Lastname uparrow J Firstname
Some questions:
1. what version of Excel are you using?
2. have you considered using a SharePoint list instead of Excel? In many cases these lists provide much more functionality than what you get in an Excel file.
Excel 365, sorry I thought it was tagged as that. I'm not familiar with .SharePoint, even whether I have it. How does it work? And wouldn't the naming still be an issue?
your tags were for Office 365 and Excel, (there are several different versions of Excel that can be used with Office 365).
A SharePoint list has a lot of similarities to an Excel Table, it just doesn't have all of the math, but for your purposes, you don't need that. Here are the instructions to get your started in case you are interested
https://support.office.com/en-us/article/Introduction-to-lists-0A1C3ACE-DEF0-44AF-B225-CFA8D92C52D7
Some nice things about Lists are that many people can work on it at the same time, you just need a browser, and it can be exported to Excel if needed
Well, I do have some files from my old Excel, but it's the ones that are converted or created in 365 that have the naming issue. How would using SharePoint help with that? I don't need to share these with anyone else, the only spreadsheet I might share hasn't had an issue, probably because the name has only letters and numbers, and it likely wouldn't work in SharePoint because it does have a lot of arithmetic in it. It also appears this would not be free.
So I still don't know why a comma is being replaced by an arrow and J in workbook titles, or have any idea how to fix it. Anyone?