MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Error: problems with editing in a datasheet view

  Asked By: Sade    Date: Feb 10    Category: MOSS    Views: 5970

I'm not sure if this is a problem with the list or what. I've never
encountered this particular error before.

We are using Mindsharp's CBTs for MOSS. It's cool- you essentially
create a site from a template, and that site includes a list w/ the
details for each training video and links to them. It's a quick and
easy way to have people access the training videos.

Problem: The list doesn't have all of the fields I need to categorize
and filter for my users. I want to be able to filter out some videos
that I don't want folks to see, and more importantly, I need to have
columns for "topic" and "audience" so these are easier to sort
through. I need users to be able to quickly identify every training
related to document libraries, or RSS, for example.

SO...I added some extra columns for this type of metadata, and I made
them lookups to two lists (called "audience" and "topic") on the same
site. This way, I can easily edit the choices if necessary (I can't
stand choice columns when it comes to updating choices).

Anyway, when I edit each item via the edit menu, I have no trouble.
Yes, I can use this tedious approach 100+ times and get what I want.
BUT I wanted to do it more quickly, via the datasheet view. That's
what's throwing a consistent (and undescriptive) error for me:

"An unexpected error has occurred. Changes to your data cannot be

No matter what I do and what I tweak in the list and the views, I
continue to get this error.

Any ideas on why I cannot use the datasheet view, but I am able to
edit each item individually?



4 Answers Found

Answer #1    Answered By: Bhumi Gokhale     Answered On: Feb 10

Have you checked the SharePoint logs (in the Logs folder under the
12-hive)? That's usually a good place to start.

Once you get the folder open, sort on modified date and then cause the error
to happen again. Then refresh the view  of the log files and you should have
any relevant error  messages at the end of your last log file.

Answer #2    Answered By: Davon Henson     Answered On: Feb 10

I will talk to my IT guys about doing this.
Unfortunately, I don't have server access. I'll post back if we find
more details in the log files.

Answer #3    Answered By: Aakash Gavade     Answered On: Feb 10

I've seen this error  occur when you try to edit  a datasheet  view that contains
fields that are controlled directly by the system like modified by or
modification Date. Try creating a really minimal view  that only includes  ssome
identifier like the title and the two new fields. Use that view to switch to
datasheet view and see if that helps. However, the other problem  you may be
having is just that I don't think lookup columns  are directly editable in the
datasheet view. That might also cause a problem.

Answer #4    Answered By: Dara Hobbs     Answered On: Feb 10

had tried just what you suggested, but it didn't
work. I have a hunch you are right about the lookups  not being
editable in datasheet. It's just weird because the choices  from those
lookups DO show in the datasheet  view. It's just when I update and
move to a new record, I see the error  icon, and when I click
on "resolve" the details show the error I described earlier.

I have another weird MOSS issue I'm about to post... TOO many little
details and oddities not identified in MS Help!

Didn't find what you were looking for? Find more on Error: problems with editing in a datasheet view Or get search suggestion and latest updates.