+ Reply to Thread
Results 1 to 3 of 3

File size query

  1. #1
    Registered User
    Join Date
    02-16-2015
    Location
    Birmingham, UK
    MS-Off Ver
    MS Office 2010
    Posts
    7

    Post File size query

    Hi all, Does a file size increase if more and more files link to it externally?

    I have a file with around 10-15 tabs in it with hard coded financial data (~500 rows, 1000 columns each). No external links. But this file is then used by a number of different teams/ workstreams to link back to (one version of the truth), and I was wondering if that's contributing to the large file size - its 50+MB which I think is high given its just hard coded data.

    Any help would be appreciated.

    Thanks

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: File size query

    No, a workbook doesn't have any record of what workbooks link to it. What file type is it?
    Rory

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: File size query

    I just used this code to create a sample workbook:

    Please Login or Register  to view this content.
    It simply puts the row and column number for each cell into 500x1000 cells using a formula, converts the formula to values and copies the sheet.

    15 sheets is 38.6Mb
    16 sheets is 41.1Mb

    No formulae, no formatting, no Conditional Formatting

    The 16 sheet workbook had the code in it so maybe a tiny bit for that, but negligible.

    As I just created the workbooks from scratch, I know there is no bloating. The content of the cells ranges from "1 1" to "500 1000", so, not complex.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 9
    Last Post: 05-18-2023, 07:18 PM
  2. [SOLVED] Sheet Size (not file size)
    By vichisov in forum Excel General
    Replies: 4
    Last Post: 12-07-2017, 03:28 PM
  3. Size of Size of the Excel File saved on a networkdrive
    By cpmsimoes in forum Excel General
    Replies: 0
    Last Post: 08-12-2015, 06:01 AM
  4. How to get file size from a given folder as input and categorize the files based on size
    By mahendra.asapu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2015, 05:49 PM
  5. [SOLVED] if html file size < 150kb not proceed query vb code ?
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2013, 09:45 AM
  6. [SOLVED] Excel 2007 : File size has increased in size...Why
    By THORmx in forum Excel General
    Replies: 3
    Last Post: 02-12-2009, 02:39 AM
  7. Size Limit for ADO query?
    By cesw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2005, 10:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1