Problems with file from Google Sheets

SorenN

New Member
Joined
Mar 3, 2014
Messages
22
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
I downloaded a Google Sheet as an Excel file, and I am trying to copy/ cut a number of rows from a Spreadsheet into a new worksheet. When I try to paste or insert the cut rows I receive the following error message: "Excel ran out of resources while attempting to calculate one or more formulas as a result these formulas cannot be evaluated."
My workbook is not very big: 287 rows, Column J. I'm running Windows 7, Excel 2010, and have two programs open, Windows Task Manager says I'm using less than half of my CPU. I have no fancy or complicated formulas.

Have any body else had problems editing a file saved from Google Sheets? If you did what did you do to get the workbook to perform correctly?

Thanks as always! You folks are great!
-Soren
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
instead of trying to copy/paste entire rows after you insert the empty rows, try copy/paste just the range you need
 
Upvote 0
Thanks for the suggestion. I tried inserting a row as well, with no luck. I tried resting my computer, and that still didn't work. I finally got things to work by downloading a whole new file. This time, it worked by my copying (not cutting) the selected rows I need.
Although it took longer, it got the job done. :->
 
Upvote 0

Forum statistics

Threads
1,215,013
Messages
6,122,694
Members
449,092
Latest member
snoom82

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top