Is it possible to open just one or two worksheets from a document which contains for example 5 worksheets?

M

makiwara

Board Regular
Joined
Mar 8, 2018
Messages
171
I need to edit just 2 of them, and the file is large so its too much time until it loads.

Is is possible to open just the one I want to edit?

Have a nice day!
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Sort by date Sort by votes
No it isn't. You have to open a workbook as a whole. How big is it and how long does it take to open? Do you have calculation set to manual when opening it?
 
Upvote 0
You must log in or register to reply here.

Similar threads

I
  • Question
Open up all .txt files and import into Excel workbook off partial conditions
Replies
3
Views
163
ItalianPlatinum
I
G
  • Solved
Change Macro to import files from hyperlinks
2
Replies
12
Views
520
GarnesGambit
G
E
  • Question
Old XLSM files crashing Excel; looking for help to troubleshoot, please
Replies
9
Views
1K
jkpieterse
jkpieterse
R
  • Question
Sorry we couldn't find .tmp file when trying to open a file moved from one folder to another by a Macro
Replies
0
Views
239
RichWill84
R
K
  • Question
Lock Excel file so people are not in it when I need to edit it
Replies
2
Views
903
kevdragon1
K

Forum statistics

Threads
1,216,077
Messages
6,128,685
Members
449,463
Latest member
Jojomen56

Share this page

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
Back
Top