Results 1 to 4 of 4

Thread: Excel Operating on a PC
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Dec 2014
    Location
    Vista CA
    Posts
    148
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel Operating on a PC

    Where can I go to find out why excel takes so long to save a large file, continually bogs down while performing macros etc.
    I use several different large spreadsheets with lots of calculations going on, they run and save quite well on my PC but bogs down on my assistants PC.

    Here is one error that pops up:


    http://schemas.openxmlformats.org/sp...etml/2006/main">error113080_01.xmlErrors were detected in file 'N:\Purchasing\COST ANALYSIS\DRUM CHIPPING\MIXER DRUM CHIPPING INVOICE RECONCILIATION 5-23-19.xlsm'Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)

    Can anyone point me in a good trouble shooting direction on this? Thanks.


  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,818
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Excel Operating on a PC

    Does your assistant have the same version of windows / Excel ??
    Have you tried it on a 3rd and seperate machine.
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  3. #3
    Board Regular
    Join Date
    Dec 2014
    Location
    Vista CA
    Posts
    148
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Operating on a PC

    Both PC's using Windows Office 2016

  4. #4
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,818
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Excel Operating on a PC

    Repeat question....
    Same Excel version ?
    Have you tried it on a 3rd and seperate machine. ?
    How large is the file ?

    Might also pay to have a read here..

    http://www.decisionmodels.com/memlimitsc.htm
    Last edited by Michael M; Sep 17th, 2019 at 08:08 PM.
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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