+ Reply to Thread
Results 1 to 4 of 4

Macros stopped working on one server only

  1. #1
    Registered User
    Join Date
    08-22-2008
    Location
    Louisiana
    Posts
    2

    Macros stopped working on one server only

    Large spreadsheet with about 15 macros. Rows were added so macros had to be edited. I had done almost all successfully when I started getting debug errors. Then all macros in that worksheet and any new worksheet had debug errors. Trying different computers on the same server but with different versions of Excel did not help. I emailed the file to my home and macros work perfectly.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    probably security settings on server, one of mine was upgraded now anyone with win2000 has macro/save problems. the cure? upgrade to xp doh!

  3. #3
    Registered User
    Join Date
    08-22-2008
    Location
    Louisiana
    Posts
    2

    Problem solved

    While it still may be security settings on server, when the user rebooted her computer (which she didn't want to do until the end of the day), the macros were working in her file. I will see Monday if they work in the workbook that I am working on.

    Thanks.

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    to be honest reboot should have been first option.
    this happens quite often with updates across networks(virus guard updates/software updates and umpteen different things on servers.) users should be forced(YES FORCED) to reboot. Clears about 85-95% of problems

+ 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. Excel 2007 macros have stopped working
    By altidude in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-03-2009, 02:53 PM
  2. Macros are not working on a Mac
    By vjboaz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-23-2008, 03:25 PM
  3. Macros Not working when adding excel sheet to microsite
    By fastmattie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2008, 02:22 PM
  4. VBA Stopped Working!
    By SamuelT in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-16-2007, 11:12 AM
  5. My formulas stopped working
    By gmoexcel in forum Excel General
    Replies: 1
    Last Post: 11-22-2006, 10:59 PM

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