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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
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

B
  • Solved
VBA to read 1 line at a time from 2 CSVs and write them sequentially to the active workbook
Replies
8
Views
139
BakerSteve
B
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
240
RichWill84
R

Forum statistics

Threads
1,216,081
Messages
6,128,695
Members
449,464
Latest member
againofsoul

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