Removing "Foreign" objects from Excel notebook file?

  • Thread starter Thread starter WWGD
  • Start date Start date
  • Tags Tags
    Excel File
Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
3 replies · 1K views
Messages
7,822
Reaction score
13,151
TL;DR
Having trouble deleting "Foreign Object" picture-like from an Excel 2007 file.
Hi,
I'm having trouble dealing a "picture-like" object that I copied from a webpage (.html) file. It is the larger white rectangle in rows 194-195, that reads "United StatesStates"
IMG_20211209_190407_01.jpg

It just doesn't go away when I delet the the row. I tried to scrape the file directly into Excel from the site , but got a '403' error message (forbidden). How can I delete the row without affecting other files?
Thanks.
 
Physics news on Phys.org
pbuk said:
Try clicking on the picture and hitting delete.

Office 365 Family at GBP80 a year (not sure how much it is in US) is worth every penny to me.
Thank you, though I'm not sure I understand you. I'm using Excel 2007. You mean the newer versions
will (more likely) have a way of addressing this issue? And, sorry, r-clicking did not work. I just copied all previous rows into a new sheet. Hey, can't overdo the practice of data cleaning.

On a separate note, any chance you've heard of this British company Pivigo? Have you heard anything about it?
 
WWGD said:
Thank you, though I'm not sure I understand you. I'm using Excel 2007. You mean the newer versions
will (more likely) have a way of addressing this issue?
Probably not, but newer versions play a LOT better with all kinds of connections, as well as do a lot of other stuff better. If you are at all serious about data science (or anything really) on Excel you need to be on the current version.

WWGD said:
And, sorry, r-clicking did not work. I just copied all previous rows into a new sheet. Hey, can't overdo the practice of data cleaning.
Glad you got it sorted.

WWGD said:
On a separate note, any chance you've heard of this British company Pivigo? Have you heard anything about it?
Yes, haven't worked with them personally but I know they are doing stuff with clients I know. Looks like there was some corporate finance activity this Spring.
 
Reply
  • Like
Likes   Reactions: WWGD