XLimits - Links zu Webseiten mit Limitationen und Spezifikationen

Microsoft Knowledge Base-Artikel
   Allgemeine Limitationen und Spezifikationen
     Deutschsprachige Artikel
     Englischsprachige Artikel

   Spezifische Limitationen und Spezifikationen
     Microsoft Excel
     Komponenten, Visual Basic, Windows und anderes

Speicher- und Ressourcen-Probleme

Andere Websites mit Informationen über Limitationen und Speicher

Linkliste der Website xlam

Microsoft Knowledge Base-Artikel

Allgemeine Limitationen und Spezifikationen

Deutschsprachige Artikel

XL97: Spezifikationen von Excel 97
http://support.microsoft.com/?scid=kb;de;507098

XL97: Einschränkungen für Pivot-Tabellen in Microsoft Excel 97
http://support.microsoft.com/?scid=kb;de;157486

XL2000: Spezifikationen von Microsoft Excel 2000
http://support.microsoft.com/?scid=kb;de;264626

XL2002: Spezifikationen und Einschränkungen von Excel 2002
(Keine Internetseite bei Microsoft vorhanden)

XL2003: Spezifikationen und Einschränkungen von Excel 2003
http://office.microsoft.com/assistance/preview.aspx?AssetID=HP051992911031

XL2007: Spezifikationen und Einschränkungen von Excel 2007
http://office.microsoft.com/de-at/excel-help/spezifikationen-und-beschrankungen-in-excel-HP010073849.aspx

Englischsprachige Artikel

XL: Solver Limits for Constraints and Adjustable Cells
http://support.microsoft.com/?scid=kb;en-us;75714

XL97: Summary of Capability Limitations of Excel 97
http://support.microsoft.com/?scid=kb;en-us;296053

XL97: Limits of PivotTables in Microsoft Excel 97
http://support.microsoft.com/?scid=kb;en-us;157486

XL2000: Specifications of Microsoft Excel 2000
http://support.microsoft.com/?scid=kb;en-us;264626

XL2000: Limits of PivotTables in Microsoft Excel 2000
http://support.microsoft.com/?scid=kb;en-us;211517

XL2000: Maximum Times in Microsoft Excel
http://support.microsoft.com/?scid=kb;en-us;214386

XL2000: Limitations for Naming Visual Basic Modules
http://support.microsoft.com/?scid=kb;en-us;213560

XL2002: Limits of PivotTables in Microsoft Excel 2002
http://support.microsoft.com/?scid=kb;en-us;291061

XL2003: Excel specifications and limits in Excel 2003
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx

XL2007: Excel specifications and limits in Excel 2007
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx

XL2010: Excel specifications and limits in Excel 2010
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx

XL (all Versions): Description of limitations of custom functions in Excel
http://support.microsoft.com/?scid=kb;en-us;170787

XL (all Versions): How Column Widths Are Determined in Excel
http://support.microsoft.com/?scid=kb;en-us;214123

XL98/2001/X: Limits of PivotTables in Microsoft Excel (Macintosh Edition)
http://support.microsoft.com/?scid=kb;en-us;179331

XL2008: Limits in Microsoft Excel 2008 (Macintosh Edition)
http://mac2.microsoft.com/help/office/12/en-us/excel/item/91494e14-1fd0-44ff-8e76-74f3d92cfffd?category=0fa4030a-1bf8-46cd-9729-ee5cf80dff56

XL2011: Limits in Microsoft Excel 2011 (Macintosh Edition)
http://mac2.microsoft.com/help/office/14/en-us/excel/item/91494e14-1fd0-44ff-8e76-74f3d92cfffd

VB: Maximum Number of Controls on a Form
http://support.microsoft.com/?scid=kb;en-us;229756

OL97: Custom Forms and Programming Limitations (Outlook 97)
http://support.microsoft.com/?scid=kb;en-us;172752

OL98: Custom Forms and Programming Limitations (Outlook 98)
http://support.microsoft.com/?scid=kb;en-us;182402

WD2000: Operating Parameter Limitations and Specifications (Word 2000)
http://support.microsoft.com/?scid=kb;en-us;211489

Spezifische Limitationen und Spezifikationen

Microsoft Excel

XL97: Invalid Page Fault When Selecting Shared Workbook Feature
http://support.microsoft.com/?scid=kb;en-us;164428

XL97: "255 Characters in Cell" Error when Copying Worksheet
http://support.microsoft.com/?scid=kb;en-us;159729

XL97: Data Truncated to 255 Characters with Excel ODBC Driver
http://support.microsoft.com/?scid=kb;EN-US;189897

XL97/XL98: Pick From List Characters Are Limited to 255 Characters
http://support.microsoft.com/?scid=kb;en-us;156044

XL97/XL2000: Using "NoteText" and "Comment.Text" to Apply Comments (Limited to 255 Characters)
http://support.microsoft.com/?scid=kb;en-us;169767

XL97/XL2000: AutoFill of Date Causes Incorrect Date Entry After 32'766 Cells
http://support.microsoft.com/?scid=kb;en-us;215532

XL97/XL2000: Invalid Page Fault With More Than 411 Controls In UserForm
http://support.microsoft.com/?scid=kb;en-us;177842

XL97/XL2000/XL2002/XL2003: Excel Limits Number Of Manual Page Breaks To 1'026
http://support.microsoft.com/?scid=kb;en-us;284916

XL97/XL2000/XL2002/XL2003: Last Digits Changed to Zeroes When You Type Long Numbers in Cells
http://support.microsoft.com/?scid=kb;en-us;269370

XL97: Error Message "Unable to Save External Link Values"
http://support.microsoft.com/?scid=kb;en-us;178086

XL2000: Error Message "Unable to Save External Link Values"
http://support.microsoft.com/?scid=kb;en-us;214342

XL2000: Importing Text File Truncates Fields Longer Than 911 Characters
http://support.microsoft.com/?scid=kb;en-us;294951

XL2000: CTRL+SHIFT+" Keyboard Shortcut Limited to 1'024 Characters (Strg+Umschalt+;)
http://support.microsoft.com/?scid=kb;en-us;211587

XL2000: Linking Charts Does Not Work Correctly If Name Has More Than 64 Characters
http://support.microsoft.com/?scid=kb;en-us;249060

XL2000: Opening Workbook With More Than 1'370 External Links May Crashs
http://support.microsoft.com/?scid=kb;en-us;248201

XL2000: AutoComplete Works Differently After 102 Rows Past Last Occurrence
http://support.microsoft.com/?scid=kb;en-us;212069

XL2000: Fields Truncated When File Is Saved in .dbf Format
http://support.microsoft.com/?scid=kb;en-us;214064

XL2000: ";;;" Number Format Fails to Hide Cell Contents
http://support.microsoft.com/?scid=kb;en-us;211497

XL2000: Calculation of Formula in Formula Bar Returns #VALUE!
http://support.microsoft.com/?scid=kb;en-us;212013

XL2000: Regression Tool Error if There Are More Than 16 X Ranges
http://support.microsoft.com/?scid=kb;en-us;214102

XL2000/XL2002: Ersetzen per VBA funktioniert nur bis 911 Zeichen pro Zelle
http://support.microsoft.com/?scid=kb;de;509846

XL2002: Limitations of the Break Links Command
http://support.microsoft.com/?scid=kb;en-us;291984

Komponenten, Visual Basic, Windows und anderes

PROBLEM: DataGrid and MSHFlexGrid Do Not Scroll Properly Beyond 65'535 Rows
http://support.microsoft.com/?scid=kb;en-us;253211

PROBLEM: MSHFLexGrid Does Not Display More Than 2'048 Rows
http://support.microsoft.com/?scid=kb;en-us;194653

PROBLEM: "Syntax Error" with SQL Literal String Over 16'379 Bytes
http://support.microsoft.com/?scid=kb;en-us;194127

Explorer and File Manager Cannot Enumerate Path Longer Than 260 Characters
http://support.microsoft.com/?scid=kb;en-us;101635

VB4/VB5/VB6: Invalid Page Fault Occurs with More than 34 DDE Channels
http://support.microsoft.com/?scid=kb;en-us;180624

VBA5/VBA6/VB4/VB5/VB6: Seek Past VB's/VBA's 2GB File Limit
http://support.microsoft.com/?scid=kb;en-us;189981

Speicher- und Ressourcen-Probleme

XL: "Not Enough System Resources" with Controls on Zoomed Sheets
http://support.microsoft.com/?scid=kb;en-us;183503

XL97: Not Enough Memory Error When You Open an Excel Workbook
http://support.microsoft.com/?scid=kb;en-us;255622

XL97: Problems When You AutoFormat an Entire Worksheet
http://support.microsoft.com/?scid=kb;en-us;159863

XL97/XL2000/XL2002: Memory Leak Occurs When You Query an Open Excel Worksheet Using ADO
http://support.microsoft.com/?scid=kb;en-us;319998

XL2000: Memory Leak When Excel Calculates User-Defined Functions
http://support.microsoft.com/?scid=kb;en-us;265023

OFFICE: PageSetup Object Causes Memory Leak and Hangs System
http://support.microsoft.com/?scid=kb;en-us;192869

OFFICE2000/OFFICEXP: A GDI Resource Leak Occurs When a Visual Basic for Applications UserForm Is Displayed
http://support.microsoft.com/?scid=kb;en-us;321242

XL2000: Excel Considers Cell Outside Data Area As Last Cell in the Worksheet
http://support.microsoft.com/?scid=kb;en-us;230998

XL2000: Resetting the Last Cell Fixes Memory and Printing Problems
http://support.microsoft.com/?scid=kb;en-us;244435

Calling EnumObjects() Leaks a Selector
http://support.microsoft.com/?scid=kb;en-us;229670

Andere Websites mit Informationen über Limitationen und Speicher

Excelformeln: "Excelgrenzen"
http://www.excelformeln.de/tips.html?welcher=68
» Eine interessante Seite, auf der verschiedene Microsoft Excel 2000-Limitationen vorgestellt werden. Vollständig in deutscher Sprache.

EXCEL: "Slow Response and Memory Problems"
http://www.mvps.org/dmcritchie/excel/slowresp.htm
» Ein hervorragender englischer Artikel über Speicher- und Ressourcen-Probleme. Enthält Anleitungen zur Performance-Steigerung sowie eine grössere Liste mit Links zu weiteren Artikeln.

Decision Models
http://www.decisionmodels.com/index.htm
» Diese Website ist ein absolutes Muss für alle, die mehr über Speicher, Berechnen und Optimieren wissen möchten. Decision Models ist der Hersteller von Fast Excel, einer professionellen Software zur Optimierung von Excel-Arbeitsmappen.

Haben Sie Fragen, Anregungen oder einen Fehler entdeckt?
Kontakt zum Autor

Kostenlose Zähler