Analysis for Office Pulls Data Again After Hiding Keys
Howdy Sam,
Welcome to Microsoft Community.
I would assist you in issue related to Excel; however I have a quick question for you:
Is this issue experienced on a specific Excel file or on all Excel files?
1) Become to the following location and delete files from XLSTART folder and and so kickoff Excel and verify the result:
C:\Users\<your username>\AppData\Roaming\Microsoft\Excel\XLSTART
Note: You lot must enable 'Show hidden files and folders' to access 'AppData' folder and ensure to disable it later the troubleshooting procedure.
http://windows.microsoft.com/en-US/windows7/Show-subconscious-files
2) Beginning Excel in safe mode and verify the result.
Follow the below mentioned steps to start Excel safe mode:
a. Concord Windows fundamental + R.
b. Re-create and paste, or type the following command in the Open up box, and so press Enter:
Excel /safe
Note: There is space between Excel and /
Cheers.
If Excel safe works, disable the add together-ins following steps mentioned below and determine the trouble causing add-in:
a) Click on File carte du jour, click Options, Add together-ins, Go button besides Manage: Com-in Add together.
b) Check if in that location are add-ins listed, clear the check box.
c) Close the Office program and restart information technology.
d) Disable each add together-in one at a time, restart the Excel, and repeat the above procedure. If the issue reappears again, it will assist you to determine which add-in is causing this issue.
Hope information technology helps. Respond with the necessary information and the outcome for further assist.
4 people found this respond helpful
·
Was this respond helpful?
I had the same problem myself today on a file that worked fine previously.
I had not changed whatever settings at all or played around with any addins. The just active addins I had were FileNet, Lotus Quickr and Solver.
I copied the file to an network bulldoze and it worked fine for another user on the network but still no good for me.
The uncomplicated solution I found was for me was to close the file, shut excel and everything else open up on my PC, which in my case was only Lotus Notes, then shut down completely so common cold boot. Afterwards that everything was back to normal. Before I was able to close the file I did get a Microsoft Excel mistake bulletin stating " An unexpected mistake has occurred. AutoRecover has been disabled for this session of excel."
thanks
Terry
Hi Sam,
Welcome to Microsoft Community.
I would assist you in event related to Excel; yet I have a quick question for you lot:
Is this outcome experienced on a specific Excel file or on all Excel files?
1) Go to the following location and delete files from XLSTART folder and so start Excel and verify the result:
C:\Users\<your username>\AppData\Roaming\Microsoft\Excel\XLSTART
Note: You must enable 'Show subconscious files and folders' to access 'AppData' folder and ensure to disable information technology later on the troubleshooting process.
http://windows.microsoft.com/en-United states of america/windows7/Show-hidden-files
ii) Commencement Excel in safe mode and verify the result.
Follow the below mentioned steps to get-go Excel condom mode:
a. Hold Windows key + R.
b. Copy and paste, or type the following command in the Open up box, and so printing Enter:
Excel /prophylactic
Note: There is infinite between Excel and /
If Excel safe works, disable the add-ins post-obit steps mentioned below and determine the problem causing add-in:
a) Click on File menu, click Options, Add-ins, Become push besides Manage: Com-in Add.
b) Check if at that place are add together-ins listed, clear the check box.
c) Close the Role programme and restart it.
d) Disable each add-in 1 at a time, restart the Excel, and repeat the in a higher place procedure. If the effect reappears again, it will help you lot to determine which add-in is causing this issue.
Hope it helps. Reply with the necessary information and the result for farther assist.Thank You.
1 person found this answer helpful
·
Was this reply helpful?
I had the same problem myself today on a file that worked fine previously.
I had not changed whatever settings at all or played effectually with any addins. The simply active addins I had were FileNet, Lotus Quickr and Solver.
I copied the file to an network drive and information technology worked fine for another user on the network but still no skillful for me.
The simple solution I found was for me was to close the file, close excel and everything else open on my PC, which in my example was merely Lotus Notes, and then shut down completely and and so common cold boot. After that everything was back to normal. Before I was able to close the file I did go a Microsoft Excel mistake message stating " An unexpected fault has occurred. AutoRecover has been disabled for this session of excel."
thank you
Terry
Hi Sam,
Welcome to Microsoft Community.
I would assist you in effect related to Excel; nonetheless I accept a quick question for you:
Is this issue experienced on a specific Excel file or on all Excel files?
1) Become to the following location and delete files from XLSTART folder and then outset Excel and verify the event:
C:\Users\<your username>\AppData\Roaming\Microsoft\Excel\XLSTART
Annotation: You must enable 'Show hidden files and folders' to access 'AppData' folder and ensure to disable it afterwards the troubleshooting process.
http://windows.microsoft.com/en-United states/windows7/Prove-hidden-files
2) Start Excel in safe mode and verify the result.
Follow the beneath mentioned steps to start Excel safe manner:
a. Hold Windows cardinal + R.
b. Copy and paste, or type the post-obit command in the Open box, and so press Enter:
Excel /safe
Note: There is space between Excel and /
If Excel safe works, disable the add-ins following steps mentioned beneath and determine the problem causing add together-in:
a) Click on File menu, click Options, Add-ins, Go push besides Manage: Com-in Add together.
b) Check if there are add-ins listed, clear the check box.
c) Close the Function program and restart it.
d) Disable each add-in i at a time, restart the Excel, and repeat the above procedure. If the consequence reappears over again, information technology will aid yous to make up one's mind which add together-in is causing this issue.
Hope it helps. Reply with the necessary information and the result for further assistance.Thank You.
Thnx for the postal service daniel,
But i have the same issue. I deleted the xlstart folder. cleared the add ins w
were all related to Privacy.
And so i closed and opened excel.
First i typed in the cells. hit enter. cipher disappeared.
I typed in second cell,hit enter and the text disappeared.
This happened after installing Office 2016 through Microsoft 365 online. I removed and installed office 2013.
I formated the laptop and tried , same issue,
Any more estimate, delight advise.
Was this answer helpful?
I found this trouble in a spreadsheet ... solution ... after typing in the text, click on another cell rather than striking the enter cardinal ... enter cardinal = disappears ... click on a different cell = no disappear
63 people found this respond helpful
·
Was this reply helpful?
Source: https://answers.microsoft.com/en-us/msoffice/forum/all/why-does-the-data-in-excel-cell-disappear-when-i/6d105a3d-02c3-4eee-b2a0-8ae9f9220376
0 Response to "Analysis for Office Pulls Data Again After Hiding Keys"
Post a Comment