Tech Support Guy banner
Cancel

Lost formulas in Excel

2588 Views 4 Replies 2 Participants Last post by  Wayfarer19, 
W
My wife received a Microsoft Excel file. Formulas in this file are missing. For example, if cell E45 should be the SUM of a range of cells above it (i.e. E35 to E44), I see a number in E45 without a formula. If I change anything in any cell from E35 to E44, E45 will not change. The extension of the file is "xlsx". I use the latest version of Excel through Office 365 (on Windows 10). My wife is using version 2011 on a MAC. We are both seeing the same problem. The person who sent her the file does not have the same problem. What am I missing?

One more bit of information: I went under FORMULAS and selected "automatic" for calculation option - it was set to "manual". I have a feeling that this is a related issue, but I am not sure how.
Save
Like
Status
Not open for further replies.
1 - 5 of 5 Posts
etaf
when you open the file to enable editing , are you asked any questions
often macros would be disabled - but i have not seen formulas removed and replaced with the value

.xlsx - just means its a standard office 2007 or later excel file with no macros

have a read here
http://database.ittoolbox.com/group...-l/formulas-disappeared-in-excel-file-4665988
as they have seen the issue and its due to copying the sheet before sending to you

Is the sender creating a new workbook to email you ?
Save
Like
W
Wayne, thank you for following up with this problem.

When I open the file, I just receive the ordinary "Protected View" message in Excel with a button to enable editing. Nothing else. I have tried to open the file directly from the email in Outlook. I have also saved it to my desktop before opening it. It makes no difference.

I already read the article you passed on. I also read a more pertinent thread (https://forums.techguy.org/threads/solved-excel-2007-formula-vanishes.802842/). It helped me understand that things happen when sheets are saved or files are transferred from one user to another, particularly under different versions. But I am still unable to fix the issue.
Save
Like
etaf
Can she save the workbook onto a share like dropbox/onedrive , so you can access the same file - but i cant see how that file changes just by going through the email system
Save
Like
W
Wayne, I will see if we can get this through Dropbox. She asked the sender for more information as well. I will update this thread when I find out more. Thanks.
Save
Like
1 - 5 of 5 Posts
Status
Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
Hardware Virus & Other Malware Removal Off Topic Lounge Thread Games & Discussion Networking
Top