This limitation is that filenames containing characters that are not "web friendly" are strictly verboten - this includes %, & and # - and if you've worked among executives who amass a large amount of legal files you'll see these characters constantly. Additional characters are forbidden, but they can't be part of Windows filenames anyhow, such as / and \.
Additionally, SkyDrive Pro filenames may not begin or end with a space or end with a period and must not be named after special Windows' devices such as AUX, PRN, NUL, CON, COM0 through COM9 or LPT0 through LPT9.
Dare to name your files contrary to these warnings and your SkyDrive Pro icon will display its exclamation point of disapproval and your files will not be securely stored in the Cloud.
Chances are if you are coming to Office 365 and SkyDrive Pro you are not starting fresh but bringing in existing email and documents. Now, you could work through your SkyDrive Pro sync conflicts one at a time, renaming files as you go, or you could use a bulk file rename utility. I chose the latter.
I found a super powerful utility called simply enough, Bulk Rename Utility, available from www.bulkrenameutility.co.uk. Best of all, it is free and comes in 32-bit and 64-bit versions and supports Windows 8 as well as earlier versions of Windows. It simply is a powerful, free and highly useful application that is modern and supported and, importantly, works!
Download and install this utility, and prepare yourself because when you launch it for the first time you will get a shock. It presents a traditional file browser in the top left of the screen, and a list of files and folders in the top right. Yet, the bottom half of the screen is made up of a hoard of varying file renaming options - regular expressions, replacements, capitalisations, tagging from music files or photographs, and much more.
Fortunately, you do not need to master these options, and they are all set to 'off' by default.
For our SkyDrive Pro purposes, you simply need to locate your SkyDrive Pro folder, tick the box at the bottom of the screen to include subfolders, highlight all files and folders (click in the file list and press CTRL-A) then use the replace box. For instance, enter "#" as the search text and "" (ie nothing) as the replacement text, or "&" as the search text and "and" as the replacement text and so on. Before committing, review the file list as you will see the Bulk Rename Utility displays filenames both before and after letting you see exactly what is going to happen. Only when you are satisfied click the replace button and let the tool do its thing.
The author provides a donate link on his web page so you can contribute to future development of the application. How much time did it save you? How much would that have cost you to do by hand?