Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

when ever I open excel either a blank workbook or an existing one the save as window keeps popping up even if I don't select save and if I press save or cancel the window just pops open again I can't do anything in excel and the only way I can close Excel is through Task manager.
Solved by E. L. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 10/04/2018 - 11:32
Hi…Welcome to Got It Pro
User 10/04/2018 - 11:33
hi
Excelchat Expert 10/04/2018 - 11:34
Please check your keyboard, if there are any keys which are dysfunctional
Excelchat Expert 10/04/2018 - 11:34
especially backspace and delete keys
User 10/04/2018 - 11:34
it looks fine
Excelchat Expert 10/04/2018 - 11:35
is it possible to use a different keyboard and see if this issue persist?
User 10/04/2018 - 11:36
i don't have another keyboard, can I reset this one?
Excelchat Expert 10/04/2018 - 11:36
You can reinstall the driver for this keyboard
Excelchat Expert 10/04/2018 - 11:37
Also it could be due to some cache files of microsoft
Excelchat Expert 10/04/2018 - 11:37
Please follow the steps that I am going to share now to clear them.
Excelchat Expert 10/04/2018 - 11:37
Please go to C:\Program Files\Microsoft Office\Office14\XLStart
Excelchat Expert 10/04/2018 - 11:38
C:\Users\User Name\AppData\Roaming\Microsoft\Excel\XLSTART
User 10/04/2018 - 11:38
i don't know how to do that?
User 10/04/2018 - 11:39
please explain
Excelchat Expert 10/04/2018 - 11:39
You may find some files in this start up folders which is causing the issue
Excelchat Expert 10/04/2018 - 11:39
Please go to C:\Program Files\Microsoft Office\Office14\XLStart
Excelchat Expert 10/04/2018 - 11:39
See if you can some files in this folder
Excelchat Expert 10/04/2018 - 11:40
Do you see any files ?
User 10/04/2018 - 11:40
mine says Microsoft office 15 not microsoft office?
User 10/04/2018 - 11:41
I don't know what to do can you remotely log onto my computer?
Excelchat Expert 10/04/2018 - 11:41
Unfortunately, I can't take remote access of your computer
Excelchat Expert 10/04/2018 - 11:41
ok if you have MS office 15 than follow this path
User 10/04/2018 - 11:41
ok can you twll me exactly where to go to do these things?
Excelchat Expert 10/04/2018 - 11:41
C:\Program Files (x86)\Microsoft Office\Office14\XLSTART
User 10/04/2018 - 11:42
mine saiys Office 16 not Office 14
Excelchat Expert 10/04/2018 - 11:42
no problem
Excelchat Expert 10/04/2018 - 11:42
click on that
Excelchat Expert 10/04/2018 - 11:43
and locate XLSTART folder
User 10/04/2018 - 11:43
ok it doesn't say XL Start it says OSPP OSPP OSPPREARM SLERROR
User 10/04/2018 - 11:43
i have no XL start folder
Excelchat Expert 10/04/2018 - 11:44
which excel version you are using?
User 10/04/2018 - 11:44
Office16
Excelchat Expert 10/04/2018 - 11:45
can you share screenshot of each step after you click a folder?
User 10/04/2018 - 11:45
how do I do that?
Excelchat Expert 10/04/2018 - 11:46
you have to use PrintScreen from your keyboard and take a print screen and upload here for me to see and troubleshoot.
User 10/04/2018 - 11:47
I can't seen to do a print screen, im pressing shift + prt screen and nothing is happening
User 10/04/2018 - 11:48
can I just reset excel somehow?
User 10/04/2018 - 11:49
hello?
Excelchat Expert 10/04/2018 - 11:51
You can uninstall excel
Excelchat Expert 10/04/2018 - 11:51
and then reinstall it
User 10/04/2018 - 11:52
how do i do this
Excelchat Expert 10/04/2018 - 11:52
Do you know how to bring up Settings?
Excelchat Expert 10/04/2018 - 11:53
Settings for your computer
User 10/04/2018 - 11:53
will i loose all my folders?
User 10/04/2018 - 11:53
files i mean
Excelchat Expert 10/04/2018 - 11:54
You may be able to recover most of them, however some files may not be recoverable.
User 10/04/2018 - 11:55
ok shall I save them all to my portable hard drive first?
Excelchat Expert 10/04/2018 - 11:55
yes, that will be good
User 10/04/2018 - 11:57
do you think uninstalling it and reinstalling it will solve the problem?
Excelchat Expert 10/04/2018 - 11:57
But I still suggest to first check for the XLSTART folder in all your MS Office folders
User 10/04/2018 - 11:57
I can't see this folder anywhere
Excelchat Expert 10/04/2018 - 11:59
[Uploaded an Excel file]
Excelchat Expert 10/04/2018 - 11:59
This is what I see on my system.
Excelchat Expert 10/04/2018 - 12:00
So since you are on Office 16, you will find it under Office16
User 10/04/2018 - 12:00
I went to Microsoft office > Root > Office 16 and XL start is there
User 10/04/2018 - 12:01
but there are no folder when I click on it
Excelchat Expert 10/04/2018 - 12:01
ok...there is another place to check
Excelchat Expert 10/04/2018 - 12:01
C:\Users\User Name\AppData\Roaming\Microsoft\Excel\XLSTART
Excelchat Expert 10/04/2018 - 12:02
Please check here also
Excelchat Expert 10/04/2018 - 12:02
Username will be your computer Username
User 10/04/2018 - 12:03
ok I can go to c > users ? Peter & Kate (thats our name) there is no AppData but there is an option for Roaming shall I click this?
Excelchat Expert 10/04/2018 - 12:03
yes please
User 10/04/2018 - 12:04
It says Intel and nothing else
Excelchat Expert 10/04/2018 - 12:04
are you on Mac by any chance??
User 10/04/2018 - 12:04
then wireless and then nothing when I click on that.
User 10/04/2018 - 12:04
no im a PC
Excelchat Expert 10/04/2018 - 12:05
see if you can find Microsoft in this path somewhere
User 10/04/2018 - 12:05
no microsoft there
Excelchat Expert 10/04/2018 - 12:06
ok...then I guess the only option is for you to keep a back up copy of your files and then uninstall and reinstall MS office.
User 10/04/2018 - 12:07
ok will I have to pay for the softwhere again? and do I uninstall just Excel?
Excelchat Expert 10/04/2018 - 12:08
If you have already bought a licence for MS office then you do not have to pay again.
User 10/04/2018 - 12:09
ok ill do that now
Excelchat Expert 10/04/2018 - 12:09
You will just need the product key which is long string of numbers which should have come with your purchase and you can key that in when it prompts while reinstalling.
User 10/04/2018 - 12:09
ok

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