Excel Protected cells float

Asus netbook / R750jv
December 9, 2013 at 23:40:03
Specs: Windows 8, 16GB ram
Hi All
I have a weird problem with a Calculation sheet supplied by a plasterboard manufacturer.
Some of the protected cells are floating away from the original position and so I can't use them because I do not know where they belong.
I have contacted the spreadsheet supplier and they said it is an MS problem. See the screen shot here
Has anyone of you an idea what that could be?
P.s. only managed to get a link to the image and not able to attach..

message edited by Luregn

See More: Excel Protected cells float

Report •

December 10, 2013 at 09:49:40
Is this only after you scroll down on the document? If so, just give it a minute and the cells should go back to normal.

Otherwise it's definitely a MS problem. I'm not sure whether MS offers free support or not, I don't think so, though.

I would suggest uninstalling and reinstalling MS Office. No need to back everything up, your documents will only be inaccessible momentarily.

Report •

December 10, 2013 at 11:53:47
Hi techninja
It has to be something to do with Excel as it happen before on my old W 7 machine(dead). Excel is now on a W 8 laptop and newly installed.

Report •

December 10, 2013 at 13:01:05
What version of Excel are you using?

it happen before on my old W 7 machine(dead)

Same version of Excel?

If your using 2007 try doing a Diagnostic:

Running Microsoft Office Diagnostics from within Excel/Word

Click the Microsoft Office button
Click on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Resources button in the left hand pane
Click on the Diagnose button in the right hand pane
Click Continue
Click Run Diagnostics

Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button
Click All Programs
Click Microsoft Office folder
Click Microsoft Office Tools
Click Microsoft Office Diagnostics
Click Continue
Click Run Diagnostics



Report •

Related Solutions

December 11, 2013 at 00:07:51
Hi Mike
It is Office 2010 32 bit on a 64bit machine. My dead machine was w 7 32 bit with the same problem.

Report •

December 11, 2013 at 05:55:32
Have you tried doing a Repair?

Select Start
Select Control Panel
Select Uninstall Program
Select the MS Office program, DO NOT double click, simply select the program.
At the top of the screen, a "Repair" option should appear.
Select Repair

See if that helps.

Also, try running Excel in Safe Mode:

Select Start,
Select Run.

In the Open box, type: Excel.exe /s

Safe Mode bypasses any Add-Ins, among other things, that may be causing problems.

If just using Excel /s does not work, you may need to use the complete path, something like:
C:\Program Files\Microsoft Office\Office\Excel.exe /s

Then open your problem workbook, if there a no problems, then you know it's one of your Add-Ins is the culprit.



Report •

December 12, 2013 at 00:47:22
Tried all that, no change.

Report •

Ask Question