Monday, September 26, 2016

[Solved] Data Validation Lost on Reopening

Data Validation Lost on Reopening

I have added some data validation (an in-cell drop-down) to my worksheet, but when I save it, close, and reopen, the validation is gone.
I don't even have to shut down Excel - just closing the spreadsheet and reopening it makes the validation disappear.

More info: this is a 600-record spreadsheet with several formulas.
It's saved on a network and accessed by multiple people, although only one person can have it open at a time.
The drop-down values are saved on a second tab and the validation is set to a list,
and a message that pops up when you enter the cell, but no errors (i.e., someone can either select from the list or type their own thing in).
It all works perfectly until I open it up again.

There are also a couple of simple macros on the spreadsheet - not sure if this makes a difference.
(Just one to remove the filters so it can be done quickly before re-saving a file, and another to jump to the bottom of the spreadsheet to ease data entry.)

I have tried doing an "Open and repair" to no avail.

Suggestions very welcome!

Solutions to the Problem Data Validation Lost on Reopening

Download Error Fixer (Free)

Just wanted to say that I was able to track down an answer to this problem on another forum.
Apparently it has to do with the file being an xls file (I was working in Excel 2010, but the file was created in an earlier version).
I updated the file to an
xlsm file - since it contains macros - and now it seems to retain the data validation info correctly.

Tweak IE Options
  • Open Internet Explorer.
  • Go to "Tools > Internet Options > Advanced Tab".
  • Uncheck "Enable third-party browser extensions".
  • Click "Apply".
  • Reboot your computer.

Recommended Method to Repair the Problem: Data Validation Lost on Reopening:

How to Fix Data Validation Lost on Reopening with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your computer. When you open SmartPCFixer, it will perform a scan.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.

Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 -,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v. driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.,How to Fix Error 0x0000c1f5 SoluciĆ³n?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error
Read More: Solution to Error: defragment scan error in file C:\\i386\\ AGT041F.DL_,[Solution] Custom power plan still doesn't fix the 'narcolepsy' problem; the computer goes to sleep withinh 5 minutes.,How to Fix - Default Excel to Open in Same Instance?,Fast Solution to Error: Defragementation and volume shrink,How Can You Fix - Deleting an entire page while in Word Starter.?

No comments:

Post a Comment