File size is too big to open. Boss is standing over my shoulder waiting....Help please????

Kenneth37

New Member
Joined
Oct 29, 2011
Messages
5
Computer is:
Windows xp.
uses excel 2003.

The dastardly file:
(2007 excel file)


How do I open it so that I can copy the last 5 days of entry to start another file.

Yes, I told them they needed to start a new file three months ago.

What can I do now to minimize the damage and get this fixed?
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Matt Rogers

Well-known Member
Joined
Sep 23, 2011
Messages
1,030
Hi Kenneth.

Try this:

1) Copy the file in Windows Explorer in a different directory.
2) Rename your file (NewName.xls)

Good Luck!
 

bertie

Well-known Member
Joined
Jun 12, 2009
Messages
1,869
For a quick solution import it into MsAccess.
Create an extract exporting records whose date >= 3 months ago.
 

Kenneth37

New Member
Joined
Oct 29, 2011
Messages
5
Yup. Way over my head on this one. I understand what you are saying. I just don't know how to do it.

Is there anyway I can email it to you? You sound like you could do it in about 4 seconds. I would love to know how to do it, though.
 

Kenneth37

New Member
Joined
Oct 29, 2011
Messages
5

ADVERTISEMENT

Thank you. I will try that right now.
 

Kenneth37

New Member
Joined
Oct 29, 2011
Messages
5
Hi Kenneth.

Try this:

1) Copy the file in Windows Explorer in a different directory.
2) Rename your file (NewName.xls)

Good Luck!
It says...."File conversion in progress"

The it says..."The converter failed to save the file" ????
 

bertie

Well-known Member
Joined
Jun 12, 2009
Messages
1,869
If you mean me then follow these steps.
NB: I am refering to 2003 menu items from memory, so may not be exact.

Open MsAccess with a new blank database.
Click File => Import and navigate to your excel file.
Follow the on screen instructions.

This will crteate a new table, select that table
One of the menu items will be a query wizard, click that. You want to open it in design mode.
In the DATE criteria field enter your condition >=29/08/2011.
Run the query, this will create another table.
Select that table and export it, File => Export.

If you need to retain formula create a blank template from your existing file.
Import your access file into the new Excel template.

All done.

ps Welcome to the forum.
 

Kenneth37

New Member
Joined
Oct 29, 2011
Messages
5
If you mean me then follow these steps.
NB: I am refering to 2003 menu items from memory, so may not be exact.

Open MsAccess with a new blank database.
Click File => Import and navigate to your excel file.
Follow the on screen instructions.

This will crteate a new table, select that table
One of the menu items will be a query wizard, click that. You want to open it in design mode.
In the DATE criteria field enter your condition >=29/08/2011.
Run the query, this will create another table.
Select that table and export it, File => Export.

If you need to retain formula create a blank template from your existing file.
Import your access file into the new Excel template.

All done.

ps Welcome to the forum.
Thank you Mr. Bertie, I will try that. Much appreciation to everyone for all the help.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,569
Messages
5,596,918
Members
414,110
Latest member
docops

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top