Register  |  Sign In
View unanswered posts | View active topics It is currently Fri Dec 14, 2018 2:26 pm



Reply to topic  [ 3 posts ] 
 I need help with excel 
Author Message
Extraordinary
User avatar

Joined: Thu Oct 21, 2004 9:30 pm
Posts: 11940
Location: Stroudsburg, PA
Post I need help with excel
I can't update the Rotten Tomatoes chart because of an Excel problem, and even when I open old files from a year ago and try to plug in the new numbers, it crashes and closes on me whenever I try to delete anything from one of the final rows. Deleting that row, deleting a bunch of rows does the same thing.

Re-installed Excel, same problem.

Any help?

_________________
Buy my books! http://michaelaventrella.com


Image


Wed Jun 27, 2018 5:40 pm
Profile WWW
Defeats all expectations
User avatar

Joined: Fri May 26, 2006 5:04 pm
Posts: 5550
Post Re: I need help with excel
Maybe avoid deleting rows unless you have to?

Make sure you make a new copy of your original file before you try anything so that it won't mess with the original copy.

- insert new rows in between and see if you can delete rows
- change the file extension to .xls
- use other Office alternatives (like Google Sheets) to open the file
- try it on another computer


Wed Jun 27, 2018 6:14 pm
Profile
Extraordinary
User avatar

Joined: Thu Oct 21, 2004 9:30 pm
Posts: 11940
Location: Stroudsburg, PA
Post Re: I need help with excel
i.hope wrote:
Maybe avoid deleting rows unless you have to?

Make sure you make a new copy of your original file before you try anything so that it won't mess with the original copy.

- insert new rows in between and see if you can delete rows
- change the file extension to .xls
- use other Office alternatives (like Google Sheets) to open the file
- try it on another computer


I figured out that if I just deleted the last row that did the addition, it worked. Who knows why.

_________________
Buy my books! http://michaelaventrella.com


Image


Wed Jun 27, 2018 6:21 pm
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 3 posts ] 

Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.