Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
See only 10 rows of data in one Sheet
Message
From
13/07/2022 20:03:52
 
General information
Forum:
Microsoft Office
Category:
Excel
Miscellaneous
Thread ID:
01684649
Message ID:
01684651
Views:
33
This message has been marked as the solution to the initial question of the thread.
I don’t know about your particular situation, but if you “regularly” hidden sheet, you can make them visible by Right clicking on a visible sheet tab and selecting Unhide (or Home -> Cells -> Format -> Unhide Sheet).

If the sheet Visible property was set to “xlSheetVeryHidden” you will need to make sure the Developer tab is active then click Code then Visual Basic, then click the sheet you want to unhide and change the Visible property to xlSheetVisible.

>Hi everybody,
>
>When I open an Excel file I see only one Sheet with title, 2 caption rows and 10 template rows. I click on Save As csv and I get a strange message about saving just the current active worksheet. I save it and get 2KB file with 13 rows.
>
>However, when I save the file with Powershell script I found online, it saves ~4K rows in slightly different format. So, I assume there is another sheet which may be hidden? How can I open it? The Excel file is ~297KB and Powershell script saved file is about same size.
>
>Thanks in advance.
>
>UPDATE. With the Powershell script I did get the names of the sheets (there are 2 in the Excel). However, I do not see the 'Master' Sheet, how can I see it?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform