View original (French)

Tab size of Excel 2013 file

bidounet84 Posted messages 476 Status Member -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello,
I have a rather heavy Excel file with several tabs.
Is it possible to find out the size that each tab represents?
Thank you in advance.

Configuration: Windows 7 / Chrome 49.0.2623.87

4 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    and if you want to know the weight in KB of each, apart from saving each tab individually in a workbook, I don't see any other way.
    Eric

    --
    By continuously trying, we eventually succeed.
    So the more it fails, the more chances we have that it works. (the Shadoks)
    In addition to the thank you (yes, it does happen!!!), remember to mark it as resolved. Thank you.
    0
  2. bidounet84 Posted messages 476 Status Member 88
     
    Thank you Mike-31, but that doesn't tell me how to know the size of a tab, unless I missed a line.
    0
    1. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Do I smell cheese?
      0
  3. bidounet84 Posted messages 476 Status Member 88
     
    Hello Eriic,
    No, no worries, there's no smell coming from the computer, I was just testing your solution first.
    But it gets quite heavy when you have about a dozen tabs open. I was wondering if there was a trick like right-click then "Properties" somewhere.
    0
    1. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      No, not that at the store.
      At the same time, you must have a pretty good idea of which ones are likely to be a bit too loaded, and that's not something to do every day.
      Be careful with the photos if you have any.
      0