Question description:
This user has given permission to use the problem statement for this
blog.
I got an error message "reference isn't valid"
I was trying to group two objects when it happened. The error message has me locked up. If I close it and click on anything else in excel it pops up again
Solved by G. D. in 58 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
12/03/2018 - 12:11
Welcome to GotitPro!
Excelchat Expert
12/03/2018 - 12:11
How may I help you ?
Excelchat Expert
12/03/2018 - 12:13
I understand you are getting error. Could you please show me the way you are doing along with your sample date ?
Excelchat Expert
12/03/2018 - 12:14
Hello!
Excelchat Expert
12/03/2018 - 12:14
Are you there ?
User
12/03/2018 - 12:14
im working on it
Excelchat Expert
12/03/2018 - 12:14
OK
User
12/03/2018 - 12:17
can you see the document preview screen?
Excelchat Expert
12/03/2018 - 12:17
Yes I can.
Excelchat Expert
12/03/2018 - 12:18
How are you grouping these objects ?
User
12/03/2018 - 12:19
I clicked on the text box and on the shape image and clicked on group
Excelchat Expert
12/03/2018 - 12:19
Select both objects using Ctrl+ click
User
12/03/2018 - 12:19
I think the group function completed succesfully
Excelchat Expert
12/03/2018 - 12:20
and then right click and choose group.
User
12/03/2018 - 12:21
It will not let me do anything! if I click OK on the error message it closes. When I try to click on anything it pops up again
Excelchat Expert
12/03/2018 - 12:23
Can you share your sheet with me ?
User
12/03/2018 - 12:23
your advice on how to group is not useful. I did all those steps. It grouped them. Then I tried to move thje grouped image and it crashed
Excelchat Expert
12/03/2018 - 12:23
As it is very straight way to group objects.
Excelchat Expert
12/03/2018 - 12:26
Simple select objects one by one using Ctrl button and then right click and choose Group Ungroup option.
Excelchat Expert
12/03/2018 - 12:27
You are using Desktop Excel or Google sheets ?
User
12/03/2018 - 12:27
desktop
User
12/03/2018 - 12:28
you are not reading my messages carefully. I knowq how to group. group worked. Then the error message.
User
12/03/2018 - 12:29
I can shoqw you my screen if you give me an email I will open join me meeting
Excelchat Expert
12/03/2018 - 12:29
Yes, I understand you know it already, I just repeating the steps, as I do not having the issue.
User
12/03/2018 - 12:30
Ive never had the issue. I have have grouped hundreds of times. I've never seen this error. I don't thjink it involed grouping
Excelchat Expert
12/03/2018 - 12:30
Sorry, I can not share my email with you. It is again company policy to exchange contact details.
Excelchat Expert
12/03/2018 - 12:31
Me too never had this issue.
User
12/03/2018 - 12:33
how do I kill the error
Excelchat Expert
12/03/2018 - 12:34
Do you have any macro in your sheet ?
User
12/03/2018 - 12:35
no
Excelchat Expert
12/03/2018 - 12:36
I can not explain it then why are you having the issue.
Excelchat Expert
12/03/2018 - 12:36
If you share file , I can check it at my end.
Excelchat Expert
12/03/2018 - 12:38
Please response quickly as time is running out.
User
12/03/2018 - 12:39
join.me/624-836-303 here is the link to view my screen. cut and paste it
User
12/03/2018 - 12:39
or I can share but tell me how
Excelchat Expert
12/03/2018 - 12:41
Use paper clip option at the bottom of chat box to upload file.
User
12/03/2018 - 12:43
I can't ddo it. The error message pops up as soon as I try to save the file. I closed the error and clicked on File - uipo came the error
Excelchat Expert
12/03/2018 - 12:45
Try to save as the file.
Excelchat Expert
12/03/2018 - 12:45
I looks like your file is corrupted.
Excelchat Expert
12/03/2018 - 12:48
Please save as your file with other name and try again.
User
12/03/2018 - 12:48
yes. It won't let me save the file
Excelchat Expert
12/03/2018 - 12:48
Oh!
Excelchat Expert
12/03/2018 - 12:49
Did you restart your system? Sometimes it resolve the issue.
Excelchat Expert
12/03/2018 - 12:49
You can copy paste your data in new excel file and then save it with new name.
User
12/03/2018 - 12:50
I just spent 3 hours building the spread sheet and I forgot to turn on auto save.
User
12/03/2018 - 12:50
doesn[t sound like you can help. Thanks for trying
Excelchat Expert
12/03/2018 - 12:52
Sorry, Issue is out of scope of excel.
Excelchat Expert
12/03/2018 - 12:52
Thank you for visiting us!
Excelchat Expert
12/03/2018 - 12:52
Have a good day.
Excelchat Expert
12/03/2018 - 12:52
Please leave your feedback after closing the session.
Excelchat Expert
12/03/2018 - 12:57
Please close the session.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
