Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

You cannot change part of an Array


  • Please log in to reply
8 replies to this topic

#1 barwarner

barwarner

  • Members
  • 18 posts
  • OFFLINE
  •  
  • Local time:10:57 AM

Posted 10 May 2018 - 11:13 AM

I created a spreadsheet in Excel 2010.  I went to edit it today and got the message "You cannot change part of an Array".  I do not knowingly have any arrays on this spreadsheet, so I don't know what array the error is referring to.  How can I proceed to edit this spreadsheet?  Thanks.

 

Barry



BC AdBot (Login to Remove)

 


#2 Humannpower

Humannpower

  • Members
  • 136 posts
  • OFFLINE
  •  
  • Local time:10:57 AM

Posted 10 May 2018 - 11:30 AM

Click on Find & Select on the Home tab, then select Go to special, and select Current Array and that should find the array that was created.

Next Copy the cell and then do a Paste Values


Edited by Humannpower, 10 May 2018 - 11:31 AM.


#3 barwarner

barwarner
  • Topic Starter

  • Members
  • 18 posts
  • OFFLINE
  •  
  • Local time:10:57 AM

Posted 10 May 2018 - 11:34 AM

Thanks, but when I follow your instructions I get a "No cells were found" message.



#4 Humannpower

Humannpower

  • Members
  • 136 posts
  • OFFLINE
  •  
  • Local time:10:57 AM

Posted 10 May 2018 - 11:41 AM

Do you have more than one sheet?



#5 barwarner

barwarner
  • Topic Starter

  • Members
  • 18 posts
  • OFFLINE
  •  
  • Local time:10:57 AM

Posted 10 May 2018 - 11:50 AM

No - just a rather simple one sheet spreadsheet.  It's only 50 rows and I'm just trying to delete one of the rows.



#6 Humannpower

Humannpower

  • Members
  • 136 posts
  • OFFLINE
  •  
  • Local time:10:57 AM

Posted 10 May 2018 - 11:53 AM

I'd recommend doing a copy and paste values on everything then. If that doesn't work than do a Copy & Paste Values onto a new excel document



#7 barwarner

barwarner
  • Topic Starter

  • Members
  • 18 posts
  • OFFLINE
  •  
  • Local time:10:57 AM

Posted 10 May 2018 - 01:32 PM

I'll try that and let you know but I wonder if it has something to do with the following message i receive when I open up the spreadsheet:

  

 " this workbook contains links to other data sources"  then it gives me the choice to update or not - I usually select "update" even though I am not using any external data sources for the spreadsheet.



#8 barwarner

barwarner
  • Topic Starter

  • Members
  • 18 posts
  • OFFLINE
  •  
  • Local time:10:57 AM

Posted 10 May 2018 - 01:46 PM

Cutting and Pasting into a new document worked - thanks for the help



#9 Humannpower

Humannpower

  • Members
  • 136 posts
  • OFFLINE
  •  
  • Local time:10:57 AM

Posted 10 May 2018 - 02:11 PM

You're welcome






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users