We have recently migrated all our excel onto Sharepoint and have encountered a new issue. A workbook has been opened in App (desktop) and all the Data Validation that was in the previous version has disappeared. Not the dropdown arrow, but the actual Data Validation. When checked the Data Validation has reverted to Any instead of List with the associated dropdowns for each column. Ive exhausted all attempts to find out why. Has anyone had a similar experience and was able to resolve the issue? Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Open in App - Excel loses all its Data Validation
- Thread starter Mr Denove
- Start date
I'm not sure what the issue might be, but have a look at my last post in this thread:
www.mrexcel.com
A solution I offered fell victim to this same behavior. I found a work-around using VBA, but that isn't ideal. However, in my case, the formula was still present in Data Validation, but it wasn't being applied. So it somehow needed to be re-confirmed. In your case, you may want to investigate the string length in the DV Source field. Excel imposes, I believe, a 255-character limit, and if you've migrated to Sharepoint, is it conceivable that any references in the Source field would change (and become longer)?
Drop-down Dynamic - List available employees
Hi all, I'm stumped with how to proceed. I have 11 people who list their availability for each shift for each day of the month. I made a table which has each of the employees, with days 1-30 (September) and the availability A - Available, U - Unavailable. On a separate calendar sheet, I am...
Upvote
0
Interesting. So regarding the other workbooks that have no issues, they have data validation Source formulas or references that are similar to the problematic workbook?
Could you post an example of the DV Source fields for a workbook that has no problem and one that does? Feel free to replace any sensitive text with x's or gibberish, but preserve the string length and structure.
Could you post an example of the DV Source fields for a workbook that has no problem and one that does? Feel free to replace any sensitive text with x's or gibberish, but preserve the string length and structure.
Upvote
0
They are the same unfortunately i cant post examples. The DV are set ranges exactly the same in all 4 workbooks. Everything is the same other than the new data being added which is inherent to that workbook. Stored the same way, same vba etc.
Upvote
0
Similar threads
- Question
