Libro Excel con mucho tamaño

%3CLINGO-SUB%20id%3D%22lingo-sub-2076089%22%20slang%3D%22es-ES%22%3EExcel%20book%20with%20lots%20of%20size%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2076089%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%2C%20I%20have%20a%20very%20large%20Excel%20workbook.%3C%2FP%3E%3CP%3EI%20think%20the%20problem%20is%20that%20I%20have%20inadvertently%20dragged%20formulas%20to%20the%20hidden%20parts%20of%20Excel%20sheets.%3C%2FP%3E%3CP%3EBut%20how%20do%20I%20locate%20in%20the%20hidden%20part%20of%20the%20sheets%20which%20part%20is%20generating%20the%20large%20size%20to%20the%20book%3F%3C%2FP%3E%3CP%3EI%20don't%20know%20if%20I've%20explained%20myself%20well.%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3EAngelXP%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2076089%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2077448%22%20slang%3D%22en-US%22%3ERe%3A%20Libro%20Excel%20con%20mucho%20tama%C3%B1o%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2077448%22%20slang%3D%22en-US%22%3EOne%20trick%20is%20to%20press%20End%20then%20press%20Home%20and%20your%20cursor%20will%20jump%20to%20the%20bottom%20right%20hand%20corner%20of%20the%20used%20sheet%3CBR%20%2F%3EThat%20should%20flag%20which%20sheet%20contains%20the%20issue%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2091599%22%20slang%3D%22en-US%22%3ERe%3A%20Libro%20Excel%20con%20mucho%20tama%C3%B1o%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2091599%22%20slang%3D%22en-US%22%3E%3CP%3ENo%2C%20no%20he%20resuelto%20el%20problema.%20Son%2010%20hojas%20y%20con%20celdas%20ocultas.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2092574%22%20slang%3D%22es-ES%22%3ERE%3A%20Excel%20workbook%20with%20lots%20of%20size%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2092574%22%20slang%3D%22es-ES%22%3EThe%20first%20thing%20you%20will%20have%20to%20check%20out%20the%20book%20to%20visualize%20the%20hidden%20cells.%20As%20you%20indicate%20that%20you%20can't%20see%20those%20cells%2C%20it%20means%20that%20you're%20not%20the%20owner%20of%20the%20book%2C%20or%20that%20you're%20not%20authorized%20to%20edit%20it.%20Best%20regards%3C%2FLINGO-BODY%3E
Occasional Visitor

Hola, tengo un libro Excel de mucho tamaño.

Creo el problema es que he arrastrado sin querer fórmulas a las partes ocultas de las hojas de Excel.

Pero cómo localizo en la parte oculta de las hojas qué parte esta generando el gran tamaño al libro?

No sé si me he explicado bien.

Gracias.

ÁngelXP

3 Replies
One trick is to press End then press Home and your cursor will jump to the bottom right hand corner of the used sheet
That should flag which sheet contains the issue

No, no he resuelto el problema. Son 10 hojas y con celdas ocultas.

Lo primerio tendrás que desproteger el libro para visualizar las celdas ocultas. Como indicas que no puedes visualizar dichas celdas quiere decir que no eres el propietario del libro, o que no tienes autorización para editarlo. Saludos