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

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

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

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

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 Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Modern productivity – Office 2016 and Office 365 news at Ignite
Source: Modern productivity–Office news at Ignite - Microsoft Office Blogs
News
Microsoft Office Picture Manager - Office 07 - Broken File Types
After much messing around I have discovered that if you use Windows 7 'Associate a file type or protocol with a program' to set default programs for file types, it breaks the File Types selection within a given program (in my case Microsoft Office Picture Manager) and you are no longer able to use...
Microsoft Office
Free full featured office suite - SoftMaker Office 2008
SoftMaker Office is a complete and limited - featured office suite that comes with a word processor, a spreadsheet, and a presentation-graphics program. Compatible with many Microsoft Word and Excel formats. (pre Office 2010), more like office 2003. ...
Software
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
2010 Office Professional Plus to Replace 2007 Office Small Business
Good Evening Everyone, I have a few questions concerning the Installation of 2010 Office. I know that I have to uninstall Office 2007. I have no clue on how to save or where to save my documents from Office 2007. The documents consist of Word, Excel, Powerpoint and a few various folders. ...
Microsoft Office


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 15:22.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App