Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Office Ex

31 Mar 2016   #1
akb1087

windows 10 home
 
 
Office Ex

Dear All,

I am using office 365. I have one excel file from Office 2010 standard. When I open this file protected view messages shown. After enabling editing some of the data got lost. While this file working fine on another PC having office 2010 standard.

Regards,

Anil Kumar Bhakta




Attached Thumbnails
Office Ex-excel-1.jpg   Office Ex-excel-2.jpg  
My System SpecsSystem Spec
.
31 Mar 2016   #2
GEWB

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

Data is not lost. The newer Excel is using a different font so the column width (which is fixed in the origin file) is no longer wide enough to display the values.

Change the font or the font size (or auto format the column widths).

Regards,
GEWB
My System SpecsSystem Spec
31 Mar 2016   #3
akb1087

windows 10 home
 
 

Thanks.

I already done the same as you are saying. But unable to understand the problem. This problem was not related to column width or font. Data/formula is not being seen even in Formula Bar.
My System SpecsSystem Spec
.

01 Apr 2016   #4
gladson1976

Windows 7 Ultimate x64 (XP, 98SE, 95, 3.11, DOS 7.10 on VM) + Ubuntu 10.04 LTS Lucid Lynx
 
 

Is the TIME, 100% Max and 80% Max columns calculated using some formula or from some other book / sheet ?

if its a formula, can you give the formula. That might be the problem

@GEWB, I think the OP is talking about the missing values in the M, N, O columns
My System SpecsSystem Spec
01 Apr 2016   #5
GEWB

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

Quote   Quote: Originally Posted by gladson1976 View Post
Is the TIME, 100% Max and 80% Max columns calculated using some formula or from some other book / sheet ?

if its a formula, can you give the formula. That might be the problem

@GEWB, I think the OP is talking about the missing values in the M, N, O columns
Ah, yes - missed that. Thanks for pointing it out! Your analysis sounds strong. Hope the OP responds.

Regards,
GEWB
My System SpecsSystem Spec
01 Apr 2016   #6
strollin

W10 Pro desktop, W10 laptop, W10 laptop, W10 Pro tablet (all 64-bit)
 
 

If the data in columns M, N & O are calculated using a VBA macro, you may need to enable the running of macros which is turned off by default.
My System SpecsSystem Spec
Reply

 Office Ex




Thread Tools




Similar help and support threads
Thread Forum
Office 2016 and Office 365 Current Channel v1704 build 8067.2115
Source: Office 365 client update channel releases See also: Announcing April feature update for Office 2016 for Windows Desktop - Microsoft Community
News
Office 2016 and Office 365 Current Channel v1703 build 7967.2161
Source: Office 365 client update channel releases See also: May 2017 Office Update Release Office Updates
News
Office 2010 Office File Type Descriptions & Icons Incorrect
Okay, I've never posted on anything like this before so bear with me please. I've got an issue and it's driving me nuts because I can't resolve it. I'll try and give a description of what I did. Any help would be greatly appreciated! I purchased a new Dell computer (Windows 7 Home Premium...
Microsoft Office
Office 2010(Win7, 64bit) won't open Office 2007(WinXPr3 32 bit) files
Just bought a new laptop with Windows7 64bit installed-my first exposure to Windows7. I had Office 2007 installed on my old Dell 32 bit machine. I had also recently pruchased Office 2010 and installed that on my new machine. Now, when I try to open those 32bit 2007 files with 64bt 2011, Iget...
Microsoft Office
File Validation from Office 2010 to Office 2003 and Office 2007
File Validation from Office 2010 to Office 2003 and Office 2007 - Softpedia
News


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 02:45.
Twitter Facebook Google+