Harry has attended:
Excel Introduction course
Excel Intermediate course
Excel Intermediate course
Ungroup
Hi, I have 'grouped' my data base, but now when i go to 'insert' new line, it doesn't let me do anything, it comes up with error message.
Even when I ungroup, it still doesnt let me change anything, it wont even let me save it now?
How can amend this?
RE: Ungroup
Hi Harry,
Thank you for your post. I've applied grouping to some rows of data in my Excel sheet. I was able to insert a new row when I right-clicked on a row header and then clicked on "Insert".
If it still doesn't work on your side, check for other settings such as freeze panes or filters running. Turn these off as they may interfere with certain other settings. Also check for protection, merged cells or hidden rows.
I hope this helps.
Kind regards
Marius Barnard
Excel Trainer
RE: Ungroup
Hi,
I've tried it all, nothing works! Could the file be corrupted as it doesn't let me save it when I open it?
Can I send over the error message at all via email?
RE: Ungroup
Hi Harry,
Yes, please send the error message to forum@stl-training.co.uk.
Thank you
Marius
RE: Ungroup
Hi Harry, here is the file with the error that you sent.
Kind regards,
Richard
Attached files...
RE: Ungroup
Thanks - I'm thining it corrupted as it donest seem to save or anything. Ive had to cut and paste it all on to any sheet now!
RE: Ungroup
Hi Harry,
This message usually means that your computer does not have enough memory available to do the required task.
You could remove certain formattings, select fewer records, delete redundant data or close any other workbooks, programs or background processes to free up more memory.
I don't know whether this is true in your case but those are typical causes for this message to appear.
Kind regards
Marius
