All solutions IF Expert Solution – Excel IF Problems

Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc