Removing "Foreign" objects from Excel notebook file?

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

The discussion revolves around the challenge of removing a "picture-like" object from an Excel 2007 file, specifically a white rectangle in rows 194-195 that reads "United StatesStates." Users suggested clicking on the object and pressing delete, but this method was ineffective for the original poster. It was noted that newer versions of Excel, such as Office 365, offer improved functionality for handling such issues, making them more suitable for data cleaning tasks. The conversation also briefly touched on the British company Pivigo, which is involved in data science.

PREREQUISITES
  • Familiarity with Excel 2007 features and limitations
  • Basic understanding of data cleaning techniques
  • Knowledge of Office 365 capabilities
  • Awareness of web scraping and associated error messages, such as '403 Forbidden'
NEXT STEPS
  • Explore the features of Office 365 for enhanced data management
  • Learn advanced data cleaning techniques in Excel
  • Research methods for effective web scraping and handling errors
  • Investigate the services offered by Pivigo in the data science field
USEFUL FOR

This discussion is beneficial for Excel users, data analysts, and anyone involved in data cleaning or looking to upgrade their Excel skills, particularly those using older versions like Excel 2007.

WWGD
Science Advisor
Homework Helper
Messages
7,777
Reaction score
13,011
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
18K