Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Error on large Excel spreadsheet with VBA, written in '03 used inmixed '03 - '07 environment

Workbook is 28 sheets, most VBA code effects workbook formatting
(hidden sheets, password access, navigation) or protection and are
linked to buttons, toggles, checkboxes, DTpickers, combo boxes, etc.
A smaller version of this workbook was used last year without issue in
the same mixed Excel environment.

This year, after a couple of days of use, it will first cease
allowinng people to save data, if "save as" is used to save to a new
location Excel locks up, and then eventually start locking up, and
eventually refuse to open. At some point either before or at the same
time as the save issue begins, the VBA becomes unaccessible. If a
sheet/module's code is opened, an error message appears about a
missing DLL.

The Excel '07 users claim that they are always saving the workbook in
'03 format, and as stated earlier a substantially identical version
was used lasst year in the same environment without issue.

The workbook is a daily work tracking utility for a department of 22
with (user-defined date frame) reporting (that would probably be
better handled through a pivot table than the UDF/VBA/Functions method
I have employed, but you dance with the devil ya know...). It is 4MB
and can be emailed if someone wants to look that closely or is
curious.

Any ideas about what is happening, I am completely stumped...

thanks in advance
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Large file sizes after modifying spreadsheet in Excel 2007. Artagel Excel Discussion (Misc queries) 3 April 5th 07 03:34 PM
Excel function LARGE returns error 'too few arguments' Browndoff Excel Worksheet Functions 5 July 26th 06 09:55 PM
Handling large amounts of text in an Excel spreadsheet gemini Excel Discussion (Misc queries) 1 April 23rd 06 10:45 PM
Find duplicate numbers in large Excel Spreadsheet Table Excel Worksheet Functions 1 June 9th 05 04:38 PM
error message when editing a large spreadsheet Quantech Industrial Excel Worksheet Functions 0 June 9th 05 09:50 AM


All times are GMT +1. The time now is 02:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"