excel not displaying contents

[yodar44]

dbl clicking opens file but doesn't show contents.
i can tell it's got the right file because it shows the contents of the selected cell in the fx box.

it opens fine in micrsoft365excel but not in excel2010

i want to use excel2010 because it offers MDI file handling (open all files in one window), but micrsoft365excel only offers SDI (each spreadsheet opens in a separate window)

it just started doing this. it used to work fine.

it only does this on some files.

i got a workaround from another forum: ctrl+f10 fixes it temporarily, but i would like to understand what's going on and get a permanent fix.

win10pro64 v2004, excel 2010

 

[richh]

Do you have any code that sets the screen updating feature to false? Sometimes that can hang things up

 

[yodar44]

Do you have any code that sets the screen updating feature to false? Sometimes that can hang things up

not that i know of.
where would that be?

 

[richh]

It would be in the VBA editor, which is accessed via Alt+F11. It could be that you have some formulas that take a lot of time to process. Do you see a "Processing... X%" at the bottom of the Excel window?

 

[yodar44]

i do not see anything in vba that is different than another file that displays normally.

i am testing with a version of the file that doesn't have any formulas.

is there a way to attach the offending file to this reply? posting an image would be useless as it is blank.

 

[richh]

Dunno. I'd try makin a copy of the file. Use the copy and see if it still happens. You can also try copy/ pasting the contents into a new file manually and see if it happens. Seems like a version issue

 

[jocote46]

have you check if you have the rows or columns hidden?

 

[jocote46]

In excel menu, go to view and make sure that contents are not hidden. click on Unhide.

 

[yodar44]

unhide is grayed out. nothing is hidden.

i'm attaching initial and after ctrl+f10 screen shots.