Removing "Foreign" objects from Excel notebook file?

  • Thread starter Thread starter WWGD
  • Start date Start date
  • Tags Tags
    Excel File
Click For Summary

Discussion Overview

The discussion revolves around the challenge of removing an unwanted "picture-like" object from an Excel notebook file, specifically one that was copied from a webpage. Participants explore methods for deleting this object without affecting other data in the file, while also touching on the differences between Excel versions and their capabilities.

Discussion Character

  • Technical explanation
  • Debate/contested
  • Homework-related

Main Points Raised

  • One participant describes an issue with a persistent object in Excel that cannot be deleted by simply removing the row.
  • Another participant suggests clicking on the picture and hitting delete as a potential solution.
  • A later reply indicates that the participant is using Excel 2007 and questions whether newer versions might offer better solutions for this issue.
  • Some participants express that newer versions of Excel handle various connections and functionalities more effectively, implying that upgrading could be beneficial for serious data work.
  • There is a side discussion about a British company, Pivigo, with one participant sharing limited knowledge about their activities.

Areas of Agreement / Disagreement

Participants do not reach a consensus on the best method to remove the object, and there is uncertainty regarding the effectiveness of newer Excel versions compared to the one being used.

Contextual Notes

Participants mention limitations related to the version of Excel being used and the challenges of handling objects copied from web pages, but do not resolve these issues.

WWGD
Science Advisor
Homework Helper
Messages
7,785
Reaction score
13,040
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.
 
Computer science news on Phys.org
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.
 
  • Like
Likes   Reactions: WWGD
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.
 
  • Like
Likes   Reactions: WWGD

Similar threads

  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 12 ·
Replies
12
Views
9K
  • · Replies 1 ·
Replies
1
Views
3K
Replies
52
Views
5K
  • · Replies 4 ·
Replies
4
Views
4K
  • · Replies 3 ·
Replies
3
Views
5K
  • · Replies 7 ·
Replies
7
Views
8K
  • · Replies 8 ·
Replies
8
Views
6K
Replies
4
Views
3K
Replies
43
Views
20K