LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Inserting Lines Makes Formula Inactive

I downloaded a Microsoft template called General Ledger (Green,
multi-sheet/one per account code plus YTD Budget Summary and Monthly Expenses
sheets).

The workbook uses the name manager and some other field names that I can't
find definitions for.

The document worked fabulously until 1/1/10. Now, when I add a line to any
of the individual account sheets, the linked data result for the formulas on
the Monthly Expenses table disappear. The formulas are there but the result,
and the "Accounting" format just go away.

No matter what I do, the Monthly Expenses table stops working when I make
any adjustments to data on the account sheets.

Has anyone else used this workbook? Something must be embedded in it that I
just can't figure out.

HELP PLEASE! The invoices are piling up!!

 
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
Inserting PDF makes file huge Art Excel Discussion (Misc queries) 0 December 17th 08 03:49 PM
Inserting worksheet makes formulae stop working Mark Excel Discussion (Misc queries) 5 April 24th 08 07:10 PM
Inserting Text Makes Numbers Disappear! al Excel Discussion (Misc queries) 5 January 5th 08 02:38 PM
HELP PLEASE..Inserting combobox (ActiveX control) makes workbook c Inquiringmind Excel Discussion (Misc queries) 0 February 10th 07 11:01 AM
Inserting Lines or Copying lines with formulas but without data wnfisba Excel Discussion (Misc queries) 2 August 18th 06 04:41 PM


All times are GMT +1. The time now is 12:32 PM.

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"