MathHysteria

New Member
Joined
Feb 26, 2019
Messages
2
Hi,

I'm trying to extract some data from an old workbook which is locked (and the password is unknown and I cannot crack it).

I have managed to type in the location of data in the old workbook into a new workbook to extract it (=[OldSheetName.xls]OldSheetName!A1 and fill down), which works well, so I was feeling pretty pleased with myself. I then started to use Find and Replace for each sheet in the old workbook in fresh tabs in the new workbook.

This works great, except there's a space in the name of some of the Sheets in the old spreadsheet, and I get an error message when trying to use F&R to replace it (something about an internet location). Ditto with the sheet name which has an apostrophe in it.

Is there anything that can be done?

Thanks in advance!
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,503
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Welcome to the forum.

Spaces shouldn't be a problem since the formula should have apostrophes before the workbook name and after the sheet name. Are you sure you haven't got a sheet name wrong? For the sheets with apostrophes in it, double up the apostrophe.
 

MathHysteria

New Member
Joined
Feb 26, 2019
Messages
2
I figured it out in the end - we use OneDrive so the filename was pointing to the online version which Excel didn't like. Once I forced the full filename to the local version it was happy.

Was still wrestling with the apostrophe though, so thanks for that tip - works now!
 

Watch MrExcel Video

Forum statistics

Threads
1,108,908
Messages
5,525,577
Members
409,651
Latest member
Quasar Hunter

This Week's Hot Topics

Top