ASUS Tablet Excel File Problems

This is the place to discuss the latest computer hardware issues and technology. Please keep the discussion ON TOPIC!
Post Reply
Jordan987
Legit Little One
Legit Little One
Posts: 1
Joined: Fri Nov 02, 2018 3:29 am

ASUS Tablet Excel File Problems

Post by Jordan987 » Mon Jan 28, 2019 11:23 pm

I am not even sure if this is right forum but I could not post a thread question in the forum section. So hopefully I could get an answer. I have a 6-month old ASUS Tablet PO27. I downloaded an excel file (via email) that I created in my laptop. While traveling, I kept on working in the downloaded excel file on the ASUS tablet putting formulas, formating cells, etc. Then save it on the tablet every time.

However, each time I open this file to update, my formulas and formating are gone! What's in the cells are just numbers! What's happening here?

User avatar
KnightRid
Moderator
Moderator
Posts: 3924
Joined: Wed Dec 14, 2005 5:21 am
Location: Dallastown, PA

Re: ASUS Tablet Excel File Problems

Post by KnightRid » Tue Jan 29, 2019 4:49 am

https://answers.microsoft.com/en-us/mso ... cdb3752b82

Try following -

File > Options > Trust Center > Trust Center Settings > Protected View > Uncheck all options

File > Options > Trust Center > Trust Center Settings > File Block Settings > Uncheck all options.
https://www.excelforum.com/excel-formul ... -only.html
If a macro is enable the formula will not stay. I disabled the macro, added the formula, and enabled the macro and it stayed in the cell.
Cigar Blog I review for - http://www.stogiereview.com

Remember, I am opinionated and nothing I say or do reflects on anyone or anything else but me :finga:

Post Reply