I created an excel file then shared it without a password. Now my editing functionality is jeapardized. I can no longer create or edit hyperlinks, nor can I delete worksheets. Any suggestions? (over 300 worksheets in this massive file.
I created an excel file then shared it without a password. Now my editing functionality is jeapardized. I can no longer create or edit hyperlinks, nor can I delete worksheets. Any suggestions? (over 300 worksheets in this massive file.
Have you checked to see if anyone else is accessing the file at the same time as you are? This can cause similar issues.
Also, are you certain that the worksheet or workbook has not been protected by one of the individuals with whom you shared the file?
If that doesn't help, please explain (update your question with this info.) how you shared the file.
Perhaps use MS Access or something better suited to handling large chunks of info...AND it will allow hyper links.