Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel-13 formulas stop calculating on different PC?
I can use the =SUM, =VALUE, =ABS, =AVERAGE or any formula. It works fine on the original sheet I make. But when I e-mail it to someone, a very small set of cells no longer function. when e-mailed back to me I have the same error. All other cells operate without issue.
The data from the cells is coming from data that was imported from a web site, and it is only two columns of numbers of concern that we can not reference to in formulas and have the formulas (listed above) work. All other formulas (=VLOOKUP) from the same imported data set are functioning correctly. I cannot use =VLOOKUP for the error in concern. I usually get the #DIV/0 error, though the formula is using cells with numbers present in them and no zeros.
All cells are set to general. I have tried writing macros that copy the data and paste it as text to use those values, but have the same issue where formulas still fail to work properly.
All cells are set to general. I have tried writing macros that copy the data and paste it as text to use those values, but have the same issue where formulas still fail to work properly.
It did turn out to be a language issue from going to English US Standard to French European standard. When the program was run on a US English PC, it ran perfectly fine.
2 Answers
- BT_BotLv 56 years agoFavorite Answer
Not sure if this is your case but this reminds me of a problem I had.
Similar to your situation, I emailed a coworker a spreadsheet with web queries which didn't work for them.
Turns out it was a difference in Excel settings. I was using (North) American settings for numbers which meant using dots (.) to separate decimals (eg 1234.56) but my coworker's Excel was set for commas (,) (eg 1234,56). Numbers in Excel would be fine (automatically convert dots and commas) but external data from websites if different would import as text therefore leading to formulas calculating incorrectly (text would be calculated as nothing or zero and lead to a lot of #DIV/0 errors).
This was a few years ago so I don't remember what I did to fix it but I think I had a macro that would convert between dots and commas and verify if Excel reads the values as numbers and not text.
Again not sure if this is your case but if it is: great, if not, something to consider for the future. Good luck troubleshooting this one.
