M
mirage212
I have a large spreadsheet with 6 tabs each with up to 100 columns and 1000
rows. I am able to create and use a list style data validation, but when I
save the file and reopen it, the validation is gone. I can create a new
(blank) spreadsheet that uses data validation and it saves and opens
properly.
I am guessing this is due to a limitation of either the Home & Student
version that I have or due to the fact that it is a trial, or due to new
limitations in Excel07 (it worked in Excel03 in the same spreadsheet).
Can anyone say which it is. I don't want to buy the student version and
then still have it not work, but I don't want to buy the Pro version if it is
not needed or still will not work.
rows. I am able to create and use a list style data validation, but when I
save the file and reopen it, the validation is gone. I can create a new
(blank) spreadsheet that uses data validation and it saves and opens
properly.
I am guessing this is due to a limitation of either the Home & Student
version that I have or due to the fact that it is a trial, or due to new
limitations in Excel07 (it worked in Excel03 in the same spreadsheet).
Can anyone say which it is. I don't want to buy the student version and
then still have it not work, but I don't want to buy the Pro version if it is
not needed or still will not work.